row source reverts to blank upon closing table

[Jamie L]

Access 2003: i have a database split into backend and frontend with linked tables

"Master customer List" table has all customers and is linked in frontend and backend

"Customer Query" filters active customers from "Master Customer List" by status

"Pickups" table lists pickups for active customers only based on customer query

my lookup for customer combo box in pickups table is:

SELECT [Customer Query].ID, [Customer Query].[Unique Name] FROM [Customer Query] ORDER BY [Customer Query].[Supplier Name];

if i use the above lookup in design view, and save it, it works in datasheet view - there is a nice dropdown combo box with the data i need - until i close the table! when i open the table again the row source lookup is blank and data link is broken

in the backend the lookup is correct and works and stays saved. i just cant get the frontend changes to stick

tearing my hair out over here. i have two databases like this, one works, one doesnt. ive looked at the two tables and query for both of them in both the frontend and backend and cannot find a difference why one is working and the other doesnt!

[NeoPa]

It sounds like the table is already locked before you attempt to change it.

If you take a copy of the database and make this one change to it, does it save then?

[Mihail]

One more suggestion if don't work after yo do what NeoPa teach you:
remove the table from FE, run Compact and Repair database, then link again the table from BE in FE.
I have had the same problem at a time and this approach had work.

[Jamie L]

@Mihail
that did it! i knew it was just some silly bug. thanks