Importing a text file and then going to the imported record

[momon]

I have a switchboard that displays several buttons.
One of the buttons is Import. When that button is clicked, it performs a macro which imports one record into the table WSPECS from a text file.

Now, on the main switchboard, there are two fields bound to WSPECS: QUOTE NUMBER and ITEM NUMBER.

My Question: How would I make these two fields display the QUOTE NUMBER and ITEM NUMBER of the record just imported from the text file? Currently, the fields just display the first record in the table WSPECS.


Thanks in advance.

 

[jdegeorge]

You can change the import button to import the record twice...once to the main table and then once to a temporary table, upon which this form is based.

That way, you see only the one form.

If you don't need to modify this record or do any updates to other tables while this form is open it's a quick solution.

Each time you can delete the records from the temporary table, or you can have the import do a MAKE TABLE query of a specific name each time. Only thing is that if you do this you have to set Access's options to not CONFIRM the action query.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."