Ok, I am not sure I fully understand the problem but I think I had a similar issue. Maybe this will help.

In my contact table for a travel agent they stored both their home and work address. One address would be flagged as the 'mailing address' with a check box .

This was bound to a yes/no field in the table called 'UseBusinessAdd ress' (can't remember exact field name but not relevant).

So, in my query for...

Hello

The problem is this: in the criteria for a list box I reference the
parent form - and Access KEEPS changing the criteria for one that
won't work. Details below:

I have a couple of list boxes on a form. In the row source I use the
primary key of the form as a criteria.

For example, I have company details on the form. The list box shows
staff from that company. Staff is...