command button on a form, what is the VBA code to ask user a question and user reply

[LittleRock Z]

Well, IMHO, the best and easiest solution would be to use a combo box in the Header section of the form.

Does that mean the combobox would have every possible LOT number for the user to choose from?
How does it get populated when a new record is incerted into the input table?

[Welshgasman]

Yes, just create a table with all the possible lot numbers and use that. As you type 23, it will jump to 230. Providing you ordered it correctly.

[Micron]

If you already have a field with your lot numbers, don't duplicate them in another table for this. Use a query to get all of them and base the combo rowsource on that. If the lot number records have unique id's and those values are foreign key fields in the table where you want to 'jump to' some record, you might want to include these values in the 1st combo column (but hidden) and filter the records you want to go to as in

WHERE myTableRecords.ID field = combo column(0)

Not exactly like that, as that is more English than code.