Changing the Data Status of a Sub Form

[JamesBBB]

Hi All,

Im trying to be able to set a sub form to ALLOW DATA ENTRY from a button on the main form, but I can see no way of doing it. Does anybody know how to do this

The Main form is called Firedrills and the Subform is called FireSub. From the button I have tried the following, but they do not work.

Forms![firedrills]![firesub].DataEntry = true or
ME.[Firesub].DataEntry = true

I am at a bit of a loss, many thanks in advance

James

 

[PHV]

Something like this ?
Forms![firedrills]![name of firesub control].Form.DataEntry = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886