blocking recrds on conditional form

  • Thread starter Thread starter Luis
  • Start date Start date
L

Luis

Hello.

Is it possible to, on conditional form, block the records where a certain
field (Field1) has the value true ?

The idea is to only allow users to enter data on recrds that Field1 = FALSE

Thanks

Luis
 
Luis said:
Is it possible to, on conditional form, block the records where a certain
field (Field1) has the value true ?

The idea is to only allow users to enter data on recrds that Field1 = FALSE
Click to expand...


What is a "conditional form"?

What does "block the records" mean?

Taking a wild guess that you want to display all records,
but prevent any edits to records with Field1 = True, then
use a couple of lines of code in the form;s Current event
procedure:

Me.AllowEdits = Not Me.Field1
Me.AllowDeletions = Not Me.Field1
 
That makes it a very tricky problem.

How about disabling textbox2 instead of making it invisible?
You can use Conditional Formatting (Format menu) to disable
a text box on individual rows in a continuous form.
 
Back
Top