Form Design

[knox]

Sample database

https://drive.google.com/open?id=0B5...XJXZGkyd3lsZ0k

Ok, so here is what I want to do in this sample database, in the Orders form, I want to create a control (text box or combo box or whatever is more suitable) that specifies the number of products in the subform and does not allow access to commit the order in the underlying tables unless that number of products is selected in the subform.

How can this be done ?

[pbaldy]

Haven't looked at the sample db, but from the sound of it you'd have to use local tables to hold the data until you wanted to commit all of it. When you switch between bound form and subform, each will save the data. If you don't want them saving to the actual tables, you'll need to use local tables, or at least one for the subform. The main form could be unbound, and the data saved as desired.