Use Parameter Data to populate a form field

[JudyKemp]

I am trying to figure out how to take the data I enter from a parameter query
to populate a field on a form.

 

[KenSheridan via AccessMonster.com]

Include the parameter(s) as a computed column(s) in the query, e.g.

PARAMETERS
[Enter start date:] DATETIME,
[Enter end date:] DATETIME;
SELECT SomeField, SomeOtherField,
[Enter start date:] AS StartDate,
[Enter end date:] AS EndDate
FROM SomeTable
WHERE DateField BETWEEN
[Enter start date:] AND [Enter end date:];

In the above example you can then bind text box controls on the form to the
StartDate and EndDate fields.

Ken Sheridan
Stafford, England