Enabling/Disabling per Record.

  • Thread starter kryszystof via AccessMonster.com
  • Start date
K

kryszystof via AccessMonster.com

Hello and Good Afternoon,

I have new problem with a form. I am trying to make enabling based on
user input.
for example: i have six fields on my form, and llast three are automaticaly
set to false. but, I put where if user enters into field 3, field four now
becomes enabled, and so on. I did not realize that this enables field four
for all records. how can i make it just record that has data in field 3?
TIA
p.s. - i must learn more vba code, but more i learn the more i like what it
can do.
 
M

Marshall Barton

kryszystof said:
I have new problem with a form. I am trying to make enabling based on
user input.
for example: i have six fields on my form, and llast three are automaticaly
set to false. but, I put where if user enters into field 3, field four now
becomes enabled, and so on. I did not realize that this enables field four
for all records. how can i make it just record that has data in field 3?
Click to expand...


On Continuous and dataheet forms, you can not set a single
row's properties. There is only one instance of each
control (the others are just copies of its visual image) so
you see the change in all rows.

You can use Conditional Formatting (Format menu) to manage
the appearance of a control's Enabled property on each row.
 
D

david epsom dot com dot au

It doesn't really matter if field 4 is enabled
on other records: it only matters if it is
enabled on the CURRENT record. The Current
record is the record you type on.

So you can re-enable/disable in the CURRENT
EVENT of the form.

(david)
 
Top