Procedure

[linskill]

Its been over 10 years since I last used Access. My employer has enticed me into getting back in the saddle and I must admit I am enjoying myself even if my memory keeps reminding me that I am getting old...
What is the best way of ensuring a user selects a customer before they attempt to open a subform.
Thanks

 

[Gasman]

Disable the method of opening the subform until a customer value is entered?

 

[plog]

No subform, 2 forms.

First form they select a customer from a drop down and click a button. Second form opens from first, loads customer data in the header and the detail section is all the data that would have been on the subform.

 

[linskill]

No subform, 2 forms.

First form they select a customer from a drop down and click a button. Second form opens from first, loads customer data in the header and the detail section is all the data that would have been on the subform.

Thanks, It is looking like two forms is the way forward.