Another Passing value from from to query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question very similar the one just posted by DV.

I have a query with a criteria based on data from a form combo box. When the
form is ran by itself (its own main form I guess) the query works using the
data passed. The form is called "MultiGroup" and the data value is
"Building_Number".

The query criteria for the standalone form is:
[Forms]![MultiGroup]![Building_Number]

The problem: the form "MultiGroup" is also a subform of form called "Main".
When executed from "Main" I cannot get the query to work using any of the
combinations of criteria types suggested in the DV question (2/9/06). I
confirmed that the sub form name is "MultiGroup" in the "Main" form.

I am not sure if any of the suggestions in the DV question/answer worked for
DV. Any more ideas that I can try???

Thanks!!
Brent
 
Thanks,

Actually what ended up working for me was from another post put out later
this same day (It seems to be a common question).

[forms]![Main]![MultiGroup].[Form]![Building_Number]



KARL DEWEY said:
Forms]![Main]![MultiGroup]![Building_Number]


brent chapman said:
I have a question very similar the one just posted by DV.

I have a query with a criteria based on data from a form combo box. When the
form is ran by itself (its own main form I guess) the query works using the
data passed. The form is called "MultiGroup" and the data value is
"Building_Number".

The query criteria for the standalone form is:
[Forms]![MultiGroup]![Building_Number]

The problem: the form "MultiGroup" is also a subform of form called "Main".
When executed from "Main" I cannot get the query to work using any of the
combinations of criteria types suggested in the DV question (2/9/06). I
confirmed that the sub form name is "MultiGroup" in the "Main" form.

I am not sure if any of the suggestions in the DV question/answer worked for
DV. Any more ideas that I can try???

Thanks!!
Brent
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Query Parameter using multiple options 0
Access Passing data from a form to another form! 0
Access Access Report Works on One Machine but not Another 3
Specifying query parameter value from form control? 3
Running query in another database 1
Query Results in a Text Box 3
Filter subform from combo unbound text box 3

Back
Top