sql view

[charles osborne]

Does anyone know why the SQL view may not be available to
use for a table of form? I have read that you can get the
SQL view by clicking on the view button drop down list, but
it isn't there for some reason. The only view options
showing are Design View, Datasheet View, Pivot Chart View,
and Pivot Table View. I don't see the SQL View option. Can
you tell me how to find it?

Thanks!

 

[Albert D. Kallal]

Yes,

Just bring up the property sheet for the form (while in design mode).

Then select the data tab.

Now, click on the Record Source property field. Then, you can view the sql
by clicking on the [...] button that shows.

This of course assumes that your form is in fact based on some sql. If your
form is not..then you are asked if you do want to in fact open the sql query
builder...