I'm fairly new at form building - not sure what "based on the employeemain table" means. Is this a macro or VBA? i have a table and I have a form. The form gathers info from the table or tables. I would guess that my question is more detailed:
1. I have have a blank form with employee ID, first and last name. I want the user to enter the employee ID (thats it) and access go and retrieve first/last name from table and place it on the form.
2. I assume I will need a command button to click OK or cancel prior to retrieving the info. Ok to retrieve and cancel to close form. I know how to build the cancel piece.
3. Where do i put the cmd script?
Thanks - i'm learning!