blocking recrds on conditional form

[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

 

[Marshall Barton]

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

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

 

[Robert Morley]

What is a "conditional form"?

I'm guessing he mean "continuous form".


Rob

 

[Luis]

Silly me!
What I meant was Continuous Form.

I'm guessing he mean "continuous form".


Rob

 

[Marshall Barton]

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.