Hi, I'm stumped on this one and I should know this but, I cannot create a
query without data and then base a form based on the query. I'm assuming
Access won't run the query and the form is impossible to create without data?
None of the above is true.
You do need at least one table to create a query, but the table does
not need to have any records.
You can have a query based upon that table (even without records) and
then create your form using that query as recordset.
Of course if you run the query without any data in the table, you'll
get a query without any data.
Or.. If you know the name of the future query, and all of it's fields,
you can create a form using unbound controls with their control
sources set to
= [futurefieldNameA], = [futurefieldNameB], etc.,
but of course, you can't run it without getting #Name and #Error
errors because there is no query yet.
But then, why in the world would you want to?