Bound vs. Unbound Forms and Controls in Microsoft Access

[@alializadeh8195]

Thanks

[@seanmackenziedataengineering]

Welcome!

[@Aki-ht6vh]

Hi Sir. I want to use unbound text box in a continuous form that displays month(datefield) . How to bring dynamic values in each record instead of same value in all record without using control source property because control source properry make such unbound text box non editable. I am interested in using after update event to such text box to change value in underlying datefield.

[@seanmackenziedataengineering]

It is more difficult to work with these on continuous forms. One method I used is to create another field on the source table just for that purpose, then just use a data macro: kzbin.info/www/bejne/rabceqCroceSq5Y and kzbin.info/www/bejne/jXq6o4CsoNhkjdE Another way you can try is to identify the ID in the record and use something like RecordsetClone to get what you need and then do an update using After Update kzbin.info/www/bejne/eWrGpKadi9Zrqrc

[@Aki-ht6vh]

@@seanmackenziedataengineering thank you so much sir

[@liorgefen1511]

hoe did you do that when you choose a candy, the name and price automatically set? how do you related them, i cant do it

[@seanmackenziedataengineering]

I used a small amount of VBA to update the Unbound fields. At what time point in the video are you asking about?

[@Pilot123_]

Can you make a video about using access as a frontend to azure sql database? Or make a series about migrating an access database to azure and use access as a frontend to the same dabase?

[@seanmackenziedataengineering]

Thanks! In fact, this is on my list of upcoming videos.. stay tuned!

[@1977tumi]

@@seanmackenziedataengineering It will be nice to also demonstrate with SharePoint list as backend please, especially with subforms, etc