If not, and I'm not sure if you're coding your queries entirely, but if you are using Access's query designer, you can right-click in the area of the designer where the tables are and on the context menu will appear "Parameters..." you can create a parameter there and then refer to the parameter in your code.


Look up the PARAMETERS keyword. It should lead you to some solution like (off the top of my head):

PARAMETERS [Batch Number?]
INSERT INTO tblMain ( BatchNo, MIRFNumber )
SELECT tblBLS_Add.BatchNo, tblBLS_Add.MIRFNumber
FROM tblBLS_Add
WHERE (((tblBLS_Add.BatchNo) = [Batch Number?]));

...and the user receives an InputBox whose prompt is "Batch Number?".

Etcetera.