CheckBox Enabled Event

[S Jackson]

(Sorry double posted, but I forgot to put in subject line the 1st time)

I have a continuous form that allows users to upload records as Tasks to
Outlook - which works great (tada!)

I have also added an unbound checkbox control to a continuous form which I
have set Enabled: No.

I want the checkbox control (named AddedtoOutlook) to become enabled after
the user clicks the Add Task to Outlook button.

I have added the following code to the end of my event procedure:
'Set the AddedToOutlook flag, display a message
Me!AddedToOutlook = True
MsgBox "Task Added!"

My problem is that when the user selects the first record and adds it as a
task to outlook, the AddedToOutlook checkbox becomes enabled on every record
in the form, not just the record the user selected. I am pretty sure that
it is because my control is unbound and has no control source. Is there a
fix that does not include adding this checkbox as a field to my source
table?

Thanks
S. Jackson

 

[Ken Snell]

Unbound controls in a continuous forms view can display only one value...for
all records. You must bind the control to a field in the form's recordsource
in order for it to display a value that is associated to an individual
record.