Selecting records in datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 1 table database which initally prompts the user for a filter (he or
she builds the filter on the fly). Once the filter is applied, the user is
brought to a new form that displays the filtered set in datasheet view.

My question: I want to allow the user to choose a records or records in
datasheet view, filter again for those records displaying them as the records
source for another form. I understand the key is to manipulate the creation
of recordsets and make those the source for the various forms. How do I
allow a user to choose a set of records in datasheet view? Is there someway
to add a checkbox next to each record? The only way I can think of is to
show the datasheet as a subform control on an unbound form which also has a
listbox of identifiers that match the datasheet items. The user would have
to select items from the droplist to build the last form I described.

Any suggestions?
 
Bjnova,

You could add a new field, Yes/No data type, to the table that your form
is based on. Include it in the form and it should be represented there
by a checkbox for each record. Then your user can simply tick this box
for each record they want to select.
 
Thanks Steve!

Steve Schapel said:
Bjnova,

You could add a new field, Yes/No data type, to the table that your form
is based on. Include it in the form and it should be represented there
by a checkbox for each record. Then your user can simply tick this box
for each record they want to select.
Click to expand...
 
Back
Top