Listbox on a Form

[JPRENG]

I have a list box which contains all the qualifications which are stored in the table Qualifications. (Gas Safe, Asbestos etc)

On my form I want the user to select from the list box all the qualifications an employee has, then add them to that employee's record and then also dispaly the qualifications on the form next to a text box where the user enters in the date these qualifications expire. How do I do this?

 

[Cronk]

The easiest method is not to have a list box.

Presuming you have two tables tblEmployees and tblEmpQualifications for this data, then in your form bound to tblEmployees, have a sub form bound to the Quals table and in it have a combo with row source from the available qualifications and bound to the Qualification field.

 

[JPRENG]

Do you have any tutorials on how to do this?

 

[Cronk]

There would be countless of examples available.

Um, you might get lucky with a google search on "ms access youtube subforms"

 

[JPRENG]

Thank you.