Control field property

I created a form which (displayed as a continuous form) which contains a drop down menu. When I select different values a macro enable or disable an other field. However, it does this for all records for example if I go torecord 2 and select a value that enables the field and go back to record 1, the field is enabled as well although it should be disabled. Is there a way to control the property of a field on each record and not at the form level?

Thanks in advance for your help.

Thought a continuous form displays multiple rows, each row is only a copy of
the controls on the main form. As you've already seen, when you change the
property for one row, all rows are affected.

If you are using Access 2000 or later you can use Conditional Formatting to
enable/disable controls based on whatever condition you provide. Click the
control which needs to be toggled and then click Format-Conditional
Formatting. Check the online help for more specifics on how to build the
conditions.

CF is somewhat limited in what it can do but it is useful for many
situations. Stephen Lebans has put together a sample database demonstrating
some ways to use Conditional Formatting:
http://www.lebans.com/conditionalformatting.htm

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Frederic wrote:
I created a form which (displayed as a continuous form) which contains a
drop down menu. When I select different values a macro enable or disable
an other field. However, it does this for all records for example if I go
torecord 2 and select a value that enables the field and go back to
record 1, the field is enabled as well although it should be disabled. Is
there a way to control the property of a field on each record and not at
the form level?

Thanks in advance for your help.