I have a subform that has this has the record source
SELECT DISTINCTROW [extract].[ID], [extract].[Req #], [extract].[Rec Typ], [extract].[Rev Cd],Crtn Dt], [extract].[Crtn User] FROM [extract];
Obviously its from the table extract. When this form opens, i want it to ask the user "what is the name of the table that you have imported?" Instead of it always defaulting to extract.
What would be the easiest way to do this?
SELECT DISTINCTROW [extract].[ID], [extract].[Req #], [extract].[Rec Typ], [extract].[Rev Cd],Crtn Dt], [extract].[Crtn User] FROM [extract];
Obviously its from the table extract. When this form opens, i want it to ask the user "what is the name of the table that you have imported?" Instead of it always defaulting to extract.
What would be the easiest way to do this?