I have a form whose record source is a query and shows all construction
projects. There is a subform whose record souce is the same query showing
all bid dates. When I put a parameter for a bid date value, it requires me
to put in the date twice. I assume that is because the same query is running
both the main & subform.
If I use the table as the record source for the Main form & a query for the
record source of the subform, it returns all records instead of just the ones
with the date requested.
If I do a "or is null" type query to return all records, I only want to see
all records where the bid date field isn't null. How do I do that with all
of the above?