Having one form with two sub forms in it.

[TedMurphy]

Hi, I have a form with two sub forms in it the main form is named frmNewOrder and the two sub forms are named frmAirOrder and frmShippingOrder what I would like to be able to do is ensure that when Data is entered into one subform it won't entered onto another form, could you please tell me how I would be able to achieve this? Thank you very much.

Example. I enter data onto the main form and the sub form frmAirOrder I want to ensure that data cannot be entered onto the frmShippingOrder.


Thanks for your time.

 

[mark curtis]

There are a couple of things you could do, such as place or use an existing field on the main form to determine which sub form is allowed edits or visible?

e.g

You enter data onto the main form and the sub form frmAirOrder is visible because a field met criteria.

if me.txtCriteriafield is true then
me.frmAirOrder.visible=true
me.frmShippingOrder. visible=false
end if

Send me the db if you want more detailed example!

 

[TedMurphy]

Thanks, I've sent you a PM.