Create a form to enter report criteria

[Guest]

I seem to be getting something wrong with my form used to enter report
criteria.
I have used microsoft office assistance: "Create a form to enter report
criteria"
Had problems
Then used Msg posted 8/5/2004 "Correction for office 2003"
After enering the dates and selecting OK the form closes and then nothing
happens?
I am not sure where to go next?

 

[Todd Shillam]

I seem to be getting something wrong with my form used to enter report
criteria.
I have used microsoft office assistance: "Create a form to enter report
criteria"
Had problems
Then used Msg posted 8/5/2004 "Correction for office 2003"
After enering the dates and selecting OK the form closes and then nothing
happens?
I am not sure where to go next?

Start by checking the form's Record Source property--make sure you have the
correct tables and relationships established. Afterwards, make sure your
appropriate fields are added to the query builder window in the bottom pane.

Once you have the correct tables, relationships, and fields added, make sure
your form controls (your textboxes, comboboxes, etc). are bound to a
field--you do this by checking the Control Source property for each textbox,
etc.

Lastly, make sure your form is set to "continuous" or "single form"
depending on the type of form you have created (enter a single record at a
time or multiple records).

Best regards,

Todd

 

[Guest]

Thanks Todd
Worked it out at last
Cheers

Start by checking the form's Record Source property--make sure you have the
correct tables and relationships established. Afterwards, make sure your
appropriate fields are added to the query builder window in the bottom pane.

Once you have the correct tables, relationships, and fields added, make sure
your form controls (your textboxes, comboboxes, etc). are bound to a
field--you do this by checking the Control Source property for each textbox,
etc.

Lastly, make sure your form is set to "continuous" or "single form"
depending on the type of form you have created (enter a single record at a
time or multiple records).

Best regards,

Todd