Help referencing a table by name

[WinDancer]

I have a table that contains all the archived table names.

This set of tables names all have the same name, followed by the date it was archived. ie "Random 1/1/2007"

I built a form that displays those names.

When the customer picks a specific table how do I open a form to display just the data from that specific table?

Thanks,
Dave

 

[boblarson]

1. Create a form to display the table data and name it frmBaseForm

2. Bind it to one of the tables so that the controls are bound to the appropriate fields.

3. Open the base form by using this: DoCmd.OpenForm "frmBaseForm", acViewNormal

4. In the Load Event of the Base form use this code:

    Me.RecordSource = Forms!YourFormToSelectTheTableName!YourTableNameField
    Me.Requery

That SHOULD work for you.

 

[WinDancer]

Thanks, Bob. I will work on this tomorrow.

 

[WinDancer]

I had a few unplanned minutes today- your code, as usual, works perfectly..Thanks!

 

[boblarson]

That is cool because for me that was hypothetical. I haven't done something like that before, but I was hoping my logic would work. Thanks for letting me know about your success.

 

[WinDancer]

Sure did