I am trying to figure out how to take the data I enter from a parameter query
to populate a field on a form.
|
|
0
|
|
|
|
Reply
|
Utf
|
5/7/2010 10:09:00 PM |
|
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
|
|
0
|
|
|
|
Reply
|
KenSheridan
|
5/8/2010 12:51:41 AM
|
|