I have a main form with one subform linked by a one-to-many relationship on one field only.
The main form;s recordsource is a query determined and assigned from a command button on a "Find" form with drop down boxes - i'e the form is populated with data fram an appropriate query according to the criteria selected.
The button opens the main/subform but I get an "Enter parameter value" dialog box asking for the link field.
If I click OK and enter nothing the main/subform opens populated correctly.
How can I stop this "Enter paramter value" dialog box from appearing?
Any help would be very much appreciated
The main form;s recordsource is a query determined and assigned from a command button on a "Find" form with drop down boxes - i'e the form is populated with data fram an appropriate query according to the criteria selected.
The button opens the main/subform but I get an "Enter parameter value" dialog box asking for the link field.
If I click OK and enter nothing the main/subform opens populated correctly.
How can I stop this "Enter paramter value" dialog box from appearing?
Any help would be very much appreciated
Comment