arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 21:36
- Joined
- May 7, 2009
- Messages
- 19,237
what version of Access you have
if you have newer version, typing
Forms on the Criteria field of the
Query in design view, will bring
all forms in your db, and all fields
in that form.
so, if you already saved your form,
check its name on the Navigation Pane.
it will not ask any parameter if
the Correct Name is typed in the
Criteria even if the texboxname is
not correct. Also if the name of the
form has spaces between the wordings,
enclosed it in square bracket:
[Forms]![Training Statistics]![txtStart]
also on the form, make sure to format
your textboxes as Date (Property->Format->Format)
(short date, long date, medium date, etc).
if you have newer version, typing
Forms on the Criteria field of the
Query in design view, will bring
all forms in your db, and all fields
in that form.
so, if you already saved your form,
check its name on the Navigation Pane.
it will not ask any parameter if
the Correct Name is typed in the
Criteria even if the texboxname is
not correct. Also if the name of the
form has spaces between the wordings,
enclosed it in square bracket:
[Forms]![Training Statistics]![txtStart]
also on the form, make sure to format
your textboxes as Date (Property->Format->Format)
(short date, long date, medium date, etc).