Selecting a query without data as a form for entering data

R

Rob M.

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?
 
F

fredg

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?
 
R

Rob M.

Thanks Fred, I'll take your advice about creating a form with the control
sources. You're right, why would I want to create it from a query when I
don't kave to.

Thanks again.
--
Rob M. Thanks for your help and If I helped I''''m glad to be of assistance.



fredg said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top