Refresh Table Data Based On ComboBox

[t0ny84]

Hi,

Sorry in advance if this doesn't make sense!

I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time Card Microsoft Access Templates where I use a combo box to select from a list and once an employee is selected their details load in the fields on the form. I have tried importing this form and updating the source to my query but am unable to get the Embedded Macro to work. I am wondering if someone can please either explain how the Combo Box on the Templates are setup\work or alternatively what code (either Macro or Embedded Macro) could I use from scratch to have my form do the same.

Thanks in advance,
t0ny84

 

[t0ny84]

Cross Post Links

Refresh Table Data Based On ComboBox

Hi, Sorry in advance if this doesn't make sense! I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time...

www.mrexcel.com

Refresh Table Data Based On ComboBox

Hi, Sorry in advance if this doesn't make sense! I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time...

www.access-programmers.co.uk

Refresh Table Data Based On ComboBox

Cross Post Links https://www.mrexcel.com/board/threads/refresh-table-data-based-on-combobox.1178079/ https://www.access-programmers.co.uk/forums/threads/refresh-table-data-based-on-combobox.318905/ https://www.accessforums.net/showthread.php?t=84133&p=480705#post480705 I am asking this...

www.accessforums.net

 

[jackd]

I suggest you describe the "business" you are trying to support with automation in simple English - no database jargon.
This could be as simple as a description of a Team, Employee, types of movements and details to be recorded.

The Student timecard template does not have identified relationships. Further, it uses attachment fields which many will advise should be avoided.

I see this has response on Accessforums.net Refresh Table Data Based On ComboBox

 

[t0ny84]

To anyone looking at this thread for guidance - a VBA solution has been provided at:

Refresh Table Data Based On ComboBox

Cross Post Links https://www.mrexcel.com/board/threads/refresh-table-data-based-on-combobox.1178079/ https://www.access-programmers.co.uk/forums/threads/refresh-table-data-based-on-combobox.318905/ https://www.accessforums.net/showthread.php?t=84133&p=480705#post480705 I am asking this...

www.accessforums.net