Unbound field in query

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

Guest

Am I crazy or is there a way to do this!!!????

I am trying to run a query to show certain records on a form. From there
the user will select which records to use in a report. Only certain records
can be used and only the user can select which ones. Basically, I was
thinking of using an "unbound" yes/no field on the form and then, when the
form ran, the user would select which records to exclude from the report.

I'm finding it impossible to do...am I just not going about this the right
way? Any suggestions would be greatly appreciated.

Thanks.
Tim
 
timeteo said:
Am I crazy or is there a way to do this!!!????

I am trying to run a query to show certain records on a form. From there
the user will select which records to use in a report. Only certain records
can be used and only the user can select which ones. Basically, I was
thinking of using an "unbound" yes/no field on the form and then, when the
form ran, the user would select which records to exclude from the report.

I'm finding it impossible to do...am I just not going about this the right
way? Any suggestions would be greatly appreciated.
Click to expand...


If you want to select more than one record, you can't do it
with an unbound text (without getting very tricky). Why not
bind the check box to a field in the table? Multiple users
doing at the same time?
 
You don't mention how you are displaying the records on the form.

Marsh offered one approach, binding the yes/no field to a new field in the
table, one per row.

A somewhat related approach would be to use paired listboxes. The first
displays the rows retrieved by your query. The second is the "Use These
Ones" list. The user would select from the first and "move them" to the
second list. Behind the scenes, you'd need to set the yes/no and requery
the list.
 
I like that approach...that would be a good way to do it.

I wanted to try and avoid adding another field to the table since the yes/no
selection is basically "disposable" data - only needed when the form is run
and the records are selected but I guess an yes/no field won't hurt anything.

Thanks to all.

Tim
 
timeteo said:
I am trying to run a query to show certain records on a form. From there
the user will select which records to use in a report. Only certain records
can be used and only the user can select which ones. Basically, I was
thinking of using an "unbound" yes/no field on the form and then, when the
form ran, the user would select which records to exclude from the report.
Click to expand...


Albert Kallal has a very nice example of using a collection
to keep track of multi select records:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Back
Top