how to create query from form?

[asinha9]

i have a database( which I did not build!) and I need to run a query based on the fields in the form.
The problem is not all the fields located in the forms are traced back to a source table/query (at least none that i can find!)
Is there some way i can build a query from the forms itself?

[wingsgary]

Are you familiar with the Expression Builder yet????

[asinha9]

not really, but I can try!

[June7]

Those fields you can't trace are probably unbound textboxes with calculations. Open form in design view and explore.

You want to use the form as a source of criteria to open a filtered query?

Review: http://datapigtechnologies.com/flash...earchform.html

Probably a good idea for you to work through a basic tutorial book or on-line source.

[asinha9]

I opened the design view of the form and there is no control source on any field. Is there a way I can even find where the entries are in a datasheet format?

[asinha9]

Is there a way I can view the entries of this form in a data sheet?

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[asinha9]

Thank so much the form is the one called final outcome

[June7]

That form is a form/subform arrangement. It has a tab control with 3 subforms on pages of the tab control.

The main form FinalOutcome is bound to Admission table.

ICUSubform is bound to ICU table.

EndoscopySubForm is bound to Endoscopy table.

SurgerySubform is bound to Surgery table.

Every control on every form is bound. There are no queries and no calculated fields. A simple data entry form.

If you want to see all data from these 4 tables in one dataset, then build a query with the query designer. This is basic Access functionality and Access Help has guidelines.

[asinha9]

Thanks!
What about the subform in final outcome that is called D/C and CXR? I couldn't find the fields for them?

[June7]

Those are not subforms. The data controls are placed directly on pages of tab control. They are bound to fields in Admission table.

[asinha9]

Thank you so much!!!
You have been such a great help, I can't thank you enough!!
You have been awesome!!!!!