Prev: Linking two Subforms & showing name in place of ID?
Next: Form Caption Length
From: JudyKemp on 7 May 2010 18:09
I am trying to figure out how to take the data I enter from a parameter query
to populate a field on a form.
From: KenSheridan via AccessMonster.com on 7 May 2010 20:51
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

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

 | 
Pages: 1
Prev: Linking two Subforms & showing name in place of ID?
Next: Form Caption Length