Unbound field in a datasheet

  • Thread starter Thread starter Aaron WOLSKI
  • Start date Start date
A

Aaron WOLSKI

I am pulling a set of records into a datasheet and wish to include a
couple of checkboxes that are not bound to the data source but are
specific to each record.

What solutions are available so that I don't have a column of checkboxes
that all end up being the same but doesn't require adding an extra field
to the data source?

Cheers,

Aaron.
 
I am pulling a set of records into a datasheet and wish to include a
couple of checkboxes that are not bound to the data source but are
specific to each record.

What solutions are available so that I don't have a column of checkboxes
that all end up being the same but doesn't require adding an extra field
to the data source?
Click to expand...

You will find no such solution, to the best of my knowledge. You will need to
add the extra "flag" field to achieve that functionality.
 
Aaron WOLSKI said:
I am pulling a set of records into a datasheet and wish to include a
couple of checkboxes that are not bound to the data source but are
specific to each record.
Click to expand...

If they are specific to a record they will have to be part of the table.
 
Sorry, not AFAIK.

If you are talking about the Datasheet of a Table/Query,
you cannot have unbound "cells". So I am assuming that
you are talking about unbound CheckBoxes on the
DatasheetView of a Form.

When you see a Column of CheckBoxes in the DatasheetView
of the Form, they are really instances of the SAME Control
and the only way for them to show different values is that
the Control must be bound. For an unbound Control, all
instances of the Control will show the same value.

My guess is that if you want this, you need to create
a "temp" Table for Fields that bind the CheckBoxes.
Populate this "temp" Table according to the RecordSource
of the Form before you open your Form. Once you finish
with the Form, delete all Records from the "temp" Table.
I am sure there will be some complications if you want to
go this way.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top