Use Parameter Data to populate a form field

  • Follow


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


1 Replies
554 Views

(page loaded in 0.024 seconds)

Similiar Articles:
















7/20/2012 2:34:00 PM


Reply: