Good Morning,
I've created a Access DB connected to a SharePoint Table, I have 6 users using it from different locations, so they each have their own copy of the access file locally.
The issue is that I have 2 users that are able to use the drop down from a combo box but cannot select anything from it nor does it save in it's field.
The setup is simple:
2 tables: Lookup & Schedule
1 Query - Lookup_Week_of
The combo box property is set as follows:
Control Source - Week of (field on Schedule Table)
Row Source: Lookup_Week_of
No code no VB or anything.
In all cases we are using Access 2010.
Any help would be appreciated.