Input to a Query from a Form

[Kavy]

Good Day!

Can I specify an input into a query from a form?

i.e. The query below gives me a value of 'BTD Salary', which includes the subtraction of todays date from a specific start date in the calculation process. A textbox then uses the DLookup function to put the 'BTD Salary' value in my form from this query.

Is there anyway to replace the 'Date()' function below with a value from another textbox on the form so I can specify which date I want to put in the calculation?

<code>
SELECT (Date()-[Start])*[$perDay] AS [BTD Salary], [Amount]/([end]-[start]) AS [$perDay], BAccounts.Amount, BAccounts.Open, BVendors.ID
FROM BVendors INNER JOIN BAccounts ON BVendors.ID=BAccounts.BVendor
WHERE (((BAccounts.Open)=True) AND ((BVendors.ID)=1));
</code>

Thank you

Kavy

 

[Kavy]

Good day all,

It looks like I found my answer here (scroll down):

http://office.microsoft.com/en-us/access-help/use-parameters-in-queries-and-reports-HA010096314.aspx

Thank you!

Kavy