query value subform

C

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
 
J

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
 
J

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
 

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

Top