Preventing entering data suboforms' fields until Master Field is filled?

[andrejamih]

I have main form and tab control with few subforms. I have set parental control with master field and child field. The field is W/O-Number. What would be the VBA code for preventing adding data into subofrms' fields without filling Master field on main form?

[Minty]

If you set the sub form properties to filter on no data, I believe it will hide the subform contents.
Subform.FilterOnEmptyMaster

[andrejamih]

Thanks man, but it doesn't help me to solve problem of saving subforms' data into a child table. I want to prevent adding any entering data in subforms' fields until the master field in main form is filled.

[Minty]

Don't enable the subform until your main form record is no longer new? Something like

Me.YourSubformContainer.Enabled = Not Me.Newrecord

[andrejamih]

Yes, thank you, but how to get the smooth requery of the tabbed control and permanently to change behavior (When I click on button NEW RECORD, I want the tab control to "frozen" fields... And when I fill master field W/O-Number, the tab control appear unlock "unfrozen"?

[Minty]

There are a host of ways - but probably the simplest would be to save your top level record as soon as the first field is completed, then enable the sub form. So the process would be something along the lines of

New Record Button Click¬
Lock the subform tab page ¬
User enters first bit of data on master record¬ ( you could force this by setting focus to it and disabling all other controls? )
after update me.dirty - false ¬ (to save record )
unlock tab pages - (as you now have a master record.)