dgoulston
Hasn't Got A Clue
- Local time
- Today, 04:28
- Joined
- Jun 10, 2002
- Messages
- 403
dustartdate.SetFocus
dateinuse = dustartdate.text
ducalcdate.Caption = dateinuse + "*"
stDocName = "deletetb2"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "dayusagecalc"
DoCmd.OpenQuery stDocName, acNormal, acEdit
'-----------------------pause here------------------------------------
stDocName = "dayusage"
DoCmd.OpenReport stDocName, acPreview
i have the code above, is it possible to tell it to wait until the query is finished running before opening the report?
because the report relys on the query being finished but does not wait for it..
thankyou in advance
DAL
dateinuse = dustartdate.text
ducalcdate.Caption = dateinuse + "*"
stDocName = "deletetb2"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "dayusagecalc"
DoCmd.OpenQuery stDocName, acNormal, acEdit
'-----------------------pause here------------------------------------
stDocName = "dayusage"
DoCmd.OpenReport stDocName, acPreview
i have the code above, is it possible to tell it to wait until the query is finished running before opening the report?
because the report relys on the query being finished but does not wait for it..
thankyou in advance
DAL