query value subform

  • Thread starter Thread starter coyote
  • Start date Start date
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
 
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
 
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
 
Back
Top