I have a union query combining data from 2 tables (not select queries) that is a record source in a locked subform, linked on [Account]
I decided to reformat the date field for this subform view so I made it into a select query with an expression to format date.
I changed the subform record source from the union query to the select query
Now when I open the form/subform - I get a parameter box Query1.Account.
I "OK" by it, and the records that the form shows are exactly what I wanted.
Can anyone tell me what would prompt this? And is there a way I can get rid of it? I cannot find any references in sql, query design view or form fields.