rich.barry
Registered User.
- Local time
- Today, 08:19
- Joined
- Aug 19, 2001
- Messages
- 176
I have two queries and a form
Query 1 uses a To and From date as criteria that it gets from text boxes on the form, and sums the information between the 2 dates.
Query 2 turns the Query 1 sums into percentages.
Everything works fine when opening Query 1 & 2 from the database window, but when I try to open the query as a recordset, I get and error that the parameters are missing.
RecordAll.Open "SELECT * FROM qryUPT_All_Percent", db, adOpenKeyset, adLockOptimistic
The form is still open, so why does the query spit the dumy at this point?
Thanks
Richard
Query 1 uses a To and From date as criteria that it gets from text boxes on the form, and sums the information between the 2 dates.
Query 2 turns the Query 1 sums into percentages.
Everything works fine when opening Query 1 & 2 from the database window, but when I try to open the query as a recordset, I get and error that the parameters are missing.
RecordAll.Open "SELECT * FROM qryUPT_All_Percent", db, adOpenKeyset, adLockOptimistic
The form is still open, so why does the query spit the dumy at this point?
Thanks
Richard