Acess Form

Robm1955

Anyone know anything about Access? I want to create a form where a user can type in an event, and date, then from a list of staff, select who is available to work. This needs to be saved, so a report can be printed. Also, the user needs to be able to able to type in another event for the same date, and select more staff, with a possibility of selecting the same staff, as they could work one event in the morning, and another in the afternoon. I just don't know how to link the tables up, when all I would have on the main form is the Event and date. The employee table has Employee ID as autonumber. Any suggestions.

johnmc

I suggest registering with www.utteraccess.com It's free.

To lookup a value you need to add a combobox linked to the lookup table. In the "on change" have it copy the value to your main form. Hint; hide the width so only the drop down is visible.