Form & Subforms

Hello,

I am somewhat new to designing Access databases...

I have one master form that contains employee details and another subform
that has employee issues and another subform that contains meetings about the
employee issues.

I don't believe I have my forms are linked properly. My main form contains
employee ID, this is a lookup field which is calling the employees table.
When I enter the employee ID, all my other controls auto-populate. I then
have a command button which opens my subform Issues. I have the employee id
control in my issues form equalled to the employee ID in my Employee details
form (master form). However, when I go to add new employees and I click the
subform Issues, all the records are there, I would like to have a new record
when there is no employee id equalled to the ID in the employees table.

I am really lost and any help would be greatly appreciated.

Charess

Is there a reason why you aren't using a true subform that is located on your
main form? It sounds like you are simply opening a second form which
technically isn't a subform.

When you use subforms, you can set the Link Master/Child properties to
filter the records displayed in the subform to a field or fields in the main
form.

--
Duane Hookom
Microsoft Access MVP


"Charess" wrote:

Hello,

I am somewhat new to designing Access databases...

I have one master form that contains employee details and another subform
that has employee issues and another subform that contains meetings about the
employee issues.

I don't believe I have my forms are linked properly. My main form contains
employee ID, this is a lookup field which is calling the employees table.
When I enter the employee ID, all my other controls auto-populate. I then
have a command button which opens my subform Issues. I have the employee id
control in my issues form equalled to the employee ID in my Employee details
form (master form). However, when I go to add new employees and I click the
subform Issues, all the records are there, I would like to have a new record
when there is no employee id equalled to the ID in the employees table.

I am really lost and any help would be greatly appreciated.

Charess