Hi,
Well, they have me off onto a new project. I'm a user of Access that has me somewhere between novice and intermediate. Still don't know VBA, but I've created enough databases in Access to at least have the basics down.
Here's my issue:
I have a main data entry form that has three subforms (all have separate tables). I have a primary key in the main table, which is the employee ID number. I have created a relationship (one-to-many) using the main table and it's primary key to link to the subtables.
In the main data form, I have three buttons, each that goes to a separate subform/subtable.
Here's the dilemma: When I open a subform to enter a new record under the employee's ID no., I have to enter the employee number again. Is there a way to encode the Employee ID number on the subform so it automatically shows up in the subform every time I add a new record? I'm sure it's something I need to do in the properties, but I'm not sure what it is.
Any help is greatly appreciated!
JRenee