Unbound Checkbox in Datasheet View

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?
 
R

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top