Refreshing The Database

[ijergas]

Hi,

When I create a table using the following code:

Myint = Me![Combo52]
strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN, [doctoremail].D_FNAME, [doctoremail].D_LNAME, [doctoremail].P_FNAME, [doctoremail].P_LNAME INTO [Tbl_AttachPatients] FROM [doctoremail] WHERE [doctoremail].RESOURCE =" & Myint
DoCmd.RunSQL strSQL

The table is created just fine. But, when I try to reference it, it does not show up until the database is refreshed. I can do this by pressing F5 or going to the view drop down list.

My question: Is there any way I can refresh the database with code?

Thanks

josh

 

[pono1]

Best guess:

RefreshDatabaseWindow

Regards,
Tim