Link to home
Start Free TrialLog in
Avatar of rjef
rjefFlag for United States of America

asked on

Access 2013 combo box wizard with a linked table getting error

Access 2013 using combo box wizard with a linked table getting error  message 'no valid fields can be found'   See attachment
Linked-table-for-customer-combo-box.jpg
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
can you open the linked table and view records?

If not, your link may be bad, try refreshing those using the linked table manager.

You may have to delete those linked tables and link them again.
...or the table was deleted altogether.
Sometimes the Back end Developer will delete a table, ...not knowing that the Front end developer needs it for something...
;-)
This will generate the exact error you are getting...
User generated image
Also:...
What type of linked tables are you using there?
In your screenshot, I only see the "Customer" field...
Many times you get errors like this if your table is missing a Primary Key.
Am i wrong or this is a 3.5 months old question ?