Locking a control

[Fekla]

Good afternoon.

I have a form with a subform.
I have problems writing the following code:
if there are some records in the subform, lock the control in the main form.

E.G.
you can only change combo box Customer if he has placed no Orders (all the details of the orders are in the subform). plus, if there were orders, but the user deleted them.

i guess i am stuck with selecting the condition in the if-statement correctly. can anyone advise me?

thx

 

[RuralGuy]

What have you tried so far? You can look at the RecordCount of the SubForm and if 0 then lock your ComboBox in the Current event of the MainForm.

 

[Fekla]

to tell you the truth, i dont know the correct syntax.

if frmSub.RecordCount=0 Then
Me.cboCustomer.Locked=True
End If

???

 

[RuralGuy]

If Me.frmSub.FORM.RecordCount = 0 Then
Me.cboCustomer.Locked=True
End If
...assuming the name of your SubFormControl is frmSub.
Here's a link for your bookmarks. Refer to Form and Subform properties and controls