Using Access 2003 on 2000 designed database

P

Peter Crilly

Since upgrading to MS-Access 2003 one of my lookups
during data entry no longer displays any records.

I have a table called Service which has 2 fields:
ServiceID(numeric) and ServiceCode(Alpha).

Another table called Item contains a field called
ServiceCode and another called ServiceDescription.

The Item table contains multiple records for each
ServiceCode, each with a different description.

In Access 2000 I would select a ServiceCode and then do a
lookup of all the Items attached to that ServiceCode.

Since upgrading my MS-Office to 2003, no Item records
appear in the lookup window.

I have checked the tables and all records still exist.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Design (Editing Queries) 3
Using list box adds blank record to lookup table 1
Slicers and Calculated Items in Pivot Table 2
Customized Grouping in MS Access 2003 Reports 1
2000-2003 to Access 2007 Switchboard 1
Data consolidation 1
Open access 2000 database in access 2003 0
Implementing public VBA function in Access 2003, passing multiple parameters 5

Top