Software

Ask something
Discussion Locked

Record source in Access

0 helpful
3 replies

by scott brian

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to get Microsoft Access to prompt for the record source of a form every time it is opened. The tables all contain the same fields so they will link in with the forms fields. I know it would be easier to have all the data in one table, but due to poor setting up of the database originally this is not possible.

Any help would be greatly appreciated

3 replies

by john_wills

In the form's OnOpen event show the user an input box and ask for the name of the table to be used:
me.RecordSource=Inputbox("What table?","Table specification")
me.requery
I think that will do it. Of course, you will need to construct the recordsource if it uses other tables, but you can work out how to do that.

And for the next full version merge the tables.

This discussion is closed to new replies.