rjef
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
Linked-table-for-customer-combo-box.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...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...
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.
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...
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 ?
yep...
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.