If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use Parameter Data to populate a form field
I am trying to figure out how to take the data I enter from a parameter query
to populate a field on a form. |
#2
|
|||
|
|||
Use Parameter Data to populate a form field
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/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|