Is it possible to enable/disable only ONE record on a form?

[Niklas Östergren]

Hi!

Is it possible to enable/disable only ONE record on a continus form?

I have a checkbox which I would like to use to enable/disable only the
record it belongs to.
I enable/disable the textboxes like this on the Click event for the
checkbox:

Me.txtPhoneNo.Enabled = Not chkPrivateNumber
Me.cboTypeOfPlace.Enabled = Not chkPrivateNumber

The problem with this is that ALL records gets enabled/disabled not only the
one I want.

On the form I also have a unique key for each phonenumber stored in the
table <intPhoneID = Me.txtPhoneID>. txtPhoneID is not visible on the form.

Any idéas!

TIA!
// Niklas

 

[Lynn Trapp]

Niklas,
No, it is not possible. What you have to realize is that a continuous form
is actually only one form that displays in multiple instances. Thus,
whatever properties are being set for the form in one instance is being set
for it in all instances.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp