Using checkboxes to choose the correct record

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

Guest

If I have the results of a query to find a surname of a patient, and I
transfer the data from the results onto a form, is it possible to place a
ckeck box next to each surname so that I can choose the correct one, and then
by clicking a button, transfer the surname (and other info) to another form
e.g. transport booking form.

Basically I'm asking if a check box can be used like this, and if so how I
should go about making the system recognise that if checkbox 1 is checked it
is the details in textbox 1 I want and not textbox 2.

Hope that makes sense
 
You would need to add a new field to your table and then bind that to your
checkbox in your form.

To open the "other" form with the checked entries, just limit the results to
records where the checkbox field is true.

You might also want some way (an update query?) to uncheck all the records.
 
Back
Top