query value subform

[coyote]

I have a subform which is unlinked to main form. I am trying to query data
for the subform by passing a value stored from a form previously used before
the main form. The main form open event does a Dlookup and stores the value
in a variable field. I can't get the sub-form to requery with the passed
value. I execute the query by itself and it returns the data (after it
prompts me for the variable value which I enter).

any clues? (I've worked on this all day...) TIA

 

[coyote]

Figured it out on my own thanks anyway!

 

[Jeff Boyce]

You are describing "how" you are trying to solve a problem/meet a business
need (i.e., with an unlinked subform, passing a value, etc.).

If you'll describe that problem/business need, folks may be able to offer
alternate approaches that solve it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

You posted in the newsgroup to see if someone could help.

If you'll post the solution you found, you might be helping someone else.

Regards

Jeff Boyce
Microsoft Office/Access MVP