Wizard automatic queries

[Bee]

Hi,

When you use the wizard to create a form and a subform in A2003, the wizard automatically creates a query for the subform; however, the wizard doesn't seem to create a query for the parent form.

My question is:
Is the parent form pulling data directly from table?

Regards,
B

 

[cuttsy]

It creates the SQL to get the data from the table(s) which you requested in the wizard.

It places said SQL in the Record Source property of the form.

 

[Bee]

It creates the SQL to get the data from the table(s) which you requested in the wizard.

It places said SQL in the Record Source property of the form.

Did you mean subform? When I open subform > properties > Record Source, I see the SQL and if I press the Record S button, it opens the query builder.

However, the parent form does not have a record source. What does that mean please?

 

[cuttsy]

Can you clarify something for me.

You made a form(not subform, a form) using the form wizard?
And this form has no Record Source?

 

[Bee]

Can you clarify something for me.

You made a form(not subform, a form) using the form wizard?
And this form has no Record Source?

I made both a form and then a subform using the wizard. Then, I went the properties of each one of them to check how they are linked to the tables (just curiousity). Then, I noticed that the form did not have a record source, but subform had a record source.

That's why I was wondering if the form linked to the table without using a query!

Hope this is clear enough now.
B

 

[cuttsy]

The forms can be bound to a table or a query.

However if it is bound to a table you should see the table name in the Record Source property.