Access database was copied now no tables in dropdown list
Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!
Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.
In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).
Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).
If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.
You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.
Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.
And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.
If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...
Sep 13, 2009 |
Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...