• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

queries that have references on subforms

Set rst = dbs.OpenRecordset("qrysf_IvsA_Prev3mos_QrySelect", dbOpenSnapshot)

I am getting an error message about to few parmeters when I run this code.  The query calls a field from a subform which I think is causing problem but I don't know how to force the value into the query.
0
xx4525
Asked:
xx4525
1 Solution
 
cable4096Commented:
What does the query look like? Could you show us, at least in SQL View?
0
 
MarineCommented:
Does this query you builded has parameters ? If so then you can use QueryDefs object. Open a parameters collection on it , assign values to these parameters and then execute querydef.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now