drop down menu to list tables in DB

[yoshe]

Hi all,
Is there any way to make a drop down list refer to the tables in the access db? The purpose is to automate an update query: the user needs to regularly update the db with info from a table that is imported into access weekly. I would like to allow the user to select the table he has uploaded and then click go to update. Sorry if this is basic, I'm new. Many thanks for any help.

 

[Eupher]

Sure, just create a combobox on your form. Make sure the Row Source Type is Table/Query, and enter the following in the Row Source field:

SELECT MSysObjects.Id, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1))
ORDER BY MSysObjects.Name;

HTH,

Ken S.

 

[yoshe]

Thanks very much Ken!