Help needed on Sub forms in ACCESS

[JayKH]

Hi, I am really struggling here any help will be much appreciated. Just for your info I am fairly new to VBA.

Here goes........

I have a data entry form (FrmTraining) and within that form a subforn (FrmAttendeeList). The subform FrmAttendeeList needs the name of the employee being entered but instead of manual entry or combo box looup, i have a button (Add Attendee) which basically opens a continuous unbound form which list details of all employees and their shift. I want the user to be able to click on any of the names in this list which will then populate the name field in the subform FrmAttendeeList and will requery this so the user can see what he has entered.

Thanks

 

[JayKH]

Yes I could have a combo box. But I chose a new form as this displays the username shift start time and end time as well as ohet information to what team they are in who their team leader is. The idea being that the user can select the employee with knowing all this information rather than searching for it.