How to view Query

S

shep

I am using MS ACCESS 2003, the MS Template "Inventory Control"

I want to view the query for a form. I open the form in Form in design view
and click the Form Selector. When I click the Build button next to Record
Source property box, rather than getting the query I get the message, "You
invoked the query builder on a table do you want to create a query based on
th table?"

How do I get the form's query?

Thanks
 
R

Rick B

Based on that message, the form is using the table as it's data source, not
a query. Select "YES" and it will create a query and open it for you to
view/modify.

Rick B
 
S

Sprinks

Hi, Shep.

If you are getting this message, the RecordSource of this form is currently
set to a table, rather than a query.

Hope that helps.
Sprinks
 
S

shep

Thank you I understand now.

Rick B said:
Based on that message, the form is using the table as it's data source, not
a query. Select "YES" and it will create a query and open it for you to
view/modify.

Rick B
Click to expand...
 
S

shep

Thank you I understand now

Sprinks said:
Hi, Shep.

If you are getting this message, the RecordSource of this form is currently
set to a table, rather than a query.

Hope that helps.
Sprinks
Click to expand...
 
Top