referencing each record

[grgerhard]

On my form I have a check box, if it is checked I enable a few text boxes.
example

If Me.Products.value = true then
me. life.enabled = true
else
me.life.enabled = false


end if
end sub

the problem is when the option changes to enabled all records in my data base are enabled. I need to vary this on each record
thank you for your help
George

[matthewspatrick]

George,

Sounds like you are using a continuous form. Unfortunately, you are looking at one of the design limitations of continuous forms here.