I would like to...
1) Enter some criteria in a form.
2) Click on a command button to popup a list of records meeting my criteria
3) Have a message box ask if I want to change the records selected to some value I've entered on the form in an unbound textbox.
4) Update the records or not as appropriate.
I'm having two problems 1) Anything I get to popup only shows a single record. 2) Getting the criteria from step1 above to pass to the update code. If anyone has some samples or suggestions I'd be really grateful.
1) Enter some criteria in a form.
2) Click on a command button to popup a list of records meeting my criteria
3) Have a message box ask if I want to change the records selected to some value I've entered on the form in an unbound textbox.
4) Update the records or not as appropriate.
I'm having two problems 1) Anything I get to popup only shows a single record. 2) Getting the criteria from step1 above to pass to the update code. If anyone has some samples or suggestions I'd be really grateful.