Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Querydef problem

Status
Not open for further replies.
tboerner

tboerner

Programmer
Oct 19, 2001
23
US
In the following code, I'm getting some inconsistent behavior. Sometimes, the Me.RecordSource says the qryOrganization is not found. This only happens sometimes. It appears to be a timing issue. I put in a loop between the 2 lines of code, that does nothing. This alleviates the problem, but does anyone have a better way?!

' Create QueryDef.
Set qryobjOrganization = appAccess.CreateQueryDef("qryOrganization", strSQL)

Me.RecordSource = "qryOrganization"
 
Status
Not open for further replies.

Similar threads

pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
199
combo
combo
TrekBiker
  • Locked
  • Question
Using Access Remotely
Replies
2
Views
105
dhookom
dhookom
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
90
techie131
techie131
pmonett
  • Locked
  • Question
At my wits' end with Access
Replies
8
Views
118
pmonett
pmonett
nsirri
  • Locked
  • Question
Word 365 : Text Form Field Problem
Replies
3
Views
95
macropod
macropod

Part and Inventory Search

Sponsor

Back
Top