V
vmf
I have a form based on a table containing a subform based on a query of that
same table that shows only records with an ID of "P". I need the subform to
display all records with an ID of "P" when the user enters the first 3 fields
of the main form, Batch, JD, Work Type (the form has a total of 15 fields). I
linked the 2 forms on the Batch, JD, & Work Type fields.
When the first entry is made, no records are shown in the subform, however,
if a second entry is made with the same Batch, JD, & WorkTypes, the subform
is populated correctly. How can I force the subform to display data after
the 3rd field, Work Type, is populated when entering data in the form for the
first time?
Thank you for your help.
Thank you,
vmf
same table that shows only records with an ID of "P". I need the subform to
display all records with an ID of "P" when the user enters the first 3 fields
of the main form, Batch, JD, Work Type (the form has a total of 15 fields). I
linked the 2 forms on the Batch, JD, & Work Type fields.
When the first entry is made, no records are shown in the subform, however,
if a second entry is made with the same Batch, JD, & WorkTypes, the subform
is populated correctly. How can I force the subform to display data after
the 3rd field, Work Type, is populated when entering data in the form for the
first time?
Thank you for your help.
Thank you,
vmf