Inhibit edit of one text box based on the contents of another

B

BobC

The two text boxes are on the same form (subform3).
I want to inhibit the Quantity filed from being edited if the Status
field contains "Ship Requested".

The following code gives me an error 'Expected: list separator or )'
Private Sub Quantity_BeforeUpdate(Cancel As Integer)
' Inhibit txtbox if the Status field is "Ship Requested"
IIf(me.Status = "Ship Requested"; me.AllowEdits = True, _
me.AllowEdits = False)
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to inhibit editing of one text box based on the value of another 1
I want to inhibit editing of one text box based on the content ofanother 14
Update one text box based on another text box 2
Allowedits=NO but the edit is enabled? POSSIBLE BUG??? 5
Clear contents of an unbound text box on a bound form. 2
Obtain the same value of the form in a subform 2
If value selected in one field the enter date in another field 3
Contents of a drop down box based on the selection in another drop 2

Top