My main form consists of an unbound combo box which lists all employees in alphabetical order, along with their id nbr. When I set up the combo box I chose the "find the records based on my table" option.
The subform is a continuous form of work performance violations .... the user can scroll down to a particular violation and click on an "Edit This" or "Delete This" to proceed further.
The problem is that when I open the form, the violations for the first person on the combo list (Let's say John Aardvark ... the list is alphabetical) appear in the subform, even though I the main form has nothing in it yet (I haven't made any selection.)
If John Aardvark has NO violations then nothing is displayed on the subform (and this is correct.)
For some reason, when the form opens it is picking up the violations for the first person on the list and putting them in the subform. I deleted the violations for "John Aardvark" and entered some violations for #2 on the list ("John Adams") and it worked correctly ... the form opened blank in the combo list and blank in the subform.
Hopefully I have made myself somewhat clear.... any help would be appreciated.... if I have to put in a "dummy" record (before Aardvark) I suppose that would work, but there's got to be something more elegant.
The parent and child link fields are the employee IDNumber (IDN) which are unique values.
The subform is a continuous form of work performance violations .... the user can scroll down to a particular violation and click on an "Edit This" or "Delete This" to proceed further.
The problem is that when I open the form, the violations for the first person on the combo list (Let's say John Aardvark ... the list is alphabetical) appear in the subform, even though I the main form has nothing in it yet (I haven't made any selection.)
If John Aardvark has NO violations then nothing is displayed on the subform (and this is correct.)
For some reason, when the form opens it is picking up the violations for the first person on the list and putting them in the subform. I deleted the violations for "John Aardvark" and entered some violations for #2 on the list ("John Adams") and it worked correctly ... the form opened blank in the combo list and blank in the subform.
Hopefully I have made myself somewhat clear.... any help would be appreciated.... if I have to put in a "dummy" record (before Aardvark) I suppose that would work, but there's got to be something more elegant.
The parent and child link fields are the employee IDNumber (IDN) which are unique values.
