Query results in Form

[PsyberFox]

Hi,

I have created an input form, which gives input parameters to a query
extracting a range of records based on date input. The results of this query
is then directed to another form, which I've set up as a subform / subreport
and set the data properties to the query. However, when running this it asks
for the input parameters twice, I guess because I'm supposed to link the form
fields to the query fields, but cannot see where / how... please help!

Thank you!

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The 2nd method in the article explains how to use a form.

 

[PsyberFox]

This will work perfectly for a report, but I need the actual query (as in
table format) to open in the "new" form, where the user then has the ability
to edit records...

 

[Allen Browne]

You could create a form in Datasheet view (so it looks like the table).

Then OpenForm, with the WhereCondition -- just as shown for the report.

If you need th form to load all records (not just filtered to the one), pass
the criteria in OpenArgs, and use the form's Load event to FindFirst in its
RecordsetClone and assign the Bookmark.