I have an access database that is being used through data access pages. I have a search critera DAP that has input boxes for "Date" and "Employee". I am trying to find a way to query a table in the database and have the record that matches these two search criteria, populate a different DAP within the same database. I can code the SQL statement in query analyzer just fine, I however am unfamiliar with the context that would be used in a script( either vbscript or jscript). I have searched the forum extensively for lookup and passing parameters, but have not been able to find an example that fits just right.
The search DAP is called "Search"
The DAP that I would like the result to be displayed in is "Daily_Sheet"
And again the two input boxes are "Date" and "Employee"
Thanks for the help.
Ewd97
The search DAP is called "Search"
The DAP that I would like the result to be displayed in is "Daily_Sheet"
And again the two input boxes are "Date" and "Employee"
Thanks for the help.
Ewd97