Hi,

I gather that this is quite a popular question however I'm completely unable
to find a solution through google. So if anyone can provide a helping hand
it would be greatly appreciated.

I have an Access 2003 ADP which contains a bound continuous form. Everything
(for once) is working just fine except:

Based on the contents of one control in the form I'd like to prevent the
user from editing that record depending on the contents. I.e. if txtStatus =
"Cancelled" then prevent changes to that record.

Now I understand that by using continuous forms all I should have to do is
to test the value of the txtStatus control in the current event and enable /
disable the "allowedits" property of the form as the current event will run
for every record that gets the focus.

However it won't let me get that far. Everytime I reference a control in the
continuous form in the Current event of the form, the event runs but I get
the error message:

"Run-time error '2424':

The expression you entered has a field, control, or property name that <app
name> can't find."

I'm at a loss. Can anyone explain what the application is doing and how I
can change it so that it will let me examine the status of the current
record and react accordingly. The form doesn't appear to be able to be able
to reference the txtStatus control.

The on current event contains the following code:

   Private Sub Form_Current()
       If Me!txtStatus = "Cancelled" Then
           Me.AllowEdits = False
           Me.AllowDeletions = False
       Else
           Me.AllowEdits = True
           Me.AllowDeletions = True
       End If
   End Sub

Thanks

Chris.