I tried removing the calc'ed fields from the query, no change. I tried creating a new query with only the fields I needed, no change. As I said before, this works on my main admin form, and when I noticed that the query for the main admin form had only the primary table in it and no secondary tables, so I test that on the user query. It did work, and it worked after bringing in some of the secondary tables, but not others. I couldn't see the difference between the properties of these tables, so I still don't understand.
What I ended up doing is recreating the form and query, similar to the Main Admin form, with no sub form. It doesn't look exactly the way I wanted but it is functional now. (there were combo boxes on the main form that I wanted to lock out so I converted them to text boxes on the user form (which is why I needed my secondary tables in the user query)).
Functioning now though still not sure why I couldn't get it working before. I've only been working with access for a few years, so still a newbie, and I learn all the time by working through these little quirks. It's frustrating to me to have to "work around" the problem and not fully understand why something won't come together.
Thanks so much for all your help.
Lori
