Unbound Checkbox in Datasheet View

  • Thread starter Thread starter amv
  • Start date Start date
A

amv

I'm displaying a list of claim information in datasheet
view. The users need two checkboxes displayed with each
record allowing them to either approve or deny the claim.
The problem is the database does not contain an approve or
denied field to bind the checkbox to. I can update the
correct field with VBA, but is there any way to attach an
unbound checkbox to a record?
 
amv said:
I'm displaying a list of claim information in datasheet
view. The users need two checkboxes displayed with each
record allowing them to either approve or deny the claim.
The problem is the database does not contain an approve or
denied field to bind the checkbox to. I can update the
correct field with VBA, but is there any way to attach an
unbound checkbox to a record?

Nope. That is pretty close to the definition of a bound control. You'll
need to add the fields or use a separate table with a 1 to 1 relationship
that you can then pull in with a query.
 
Back
Top