query that runs a number of times = input

[Lemmy Winks]

hi, I want to put a button and textbox on a form so that when the button is clicked it will take the number in the textbox, 10 for example, and ask for the same criteria input(ID and Name) 10 times and get those 10 records into a report. Is there any way to do this?

 

[spikepl]

Yes.

But that would be an unusual way to do it. For data that already exists in your DB, you let user select it by using combos, listboxes, checkboxes or simply by clicking on a record, not by typing. If you select typing, then you have to create redundant error handling, if user mistypes something.

 

[Lemmy Winks]

im going to use combo boxes, so how would i write this query?