Subform DataEntry property (Access 2007)

[Rob W]

Greetings,

I have a subform and based on a combo box I want to change the data entry
property.

Ive had a google to look for the property name, however the code below
doesnt work as it cant find the data entry property.
Me.qryStudentsResultsDeliverysubform1.DataEntry = False

How do I access it?

Thanks
Rob

 

[Maurice]

Rob,

Depends on where the combobox resides... is it on the mainform or on the
subform. If it's on the mainform you should reference that form as well. If
its on the subform which should be data-entry you could just set
me.form.dataentry=false
as you did.

I'm assuming it's on the mainform so try this:

forms!mainformname!qryStudentsResultsDeliverysubform1.DataEntry = False

hth

 

[Rob W]

I tried the line below it expects qryStudentsResultsDelivery_subform1 to be
a field, error message
"Microsoft Office Access cant find field
'qryStudentsResultsDelivery_subform1' reffered in your expression.

Unfortunately I created a ratehr silly form name (no tusing normal naming
conventions) and also included a space :-(

Forms!frmModuleResults!qryStudentsResultsDelivery_subform1.DataEntry = False