Re: Use Button To Call/Open 2nd Form & Pass Variable

Thanks for taking the time to reply.

Given your two choices, I'd say that the first scenario is what I'm
attempting. All the called form need do is to return a record from a
different table (child table) based on the single value passed to the called
form from a single field in the record that was selected at the time the user
presses the button on the main form. The query criteria will be a single,
distinct value having a single correlating record in the child table.

Dirk Goldgar wrote:
Hi,

There are myriads of posts here and in Google groups about how to pass
variables between an opened and a called form. However, several
contradict
others and proclaim their method to be "the way" to do this.

That could be because, give the power of Access, there are often several
good ways to do something, as well as some ways that work but have
drawbacks. Or it could be because there can be different functional
requirements in what initially seems to be the same process.

I've tried many
different suggestions I've found on this board and elsewhere online -- all
[quoted text clipped - 19 lines]
arugments/syntax
that will make this work. Thanks in advance for your help.....

We need a little clarification, I think. It's one thing to pass a value to
a form when you open it, so that code on the opened form can retrieve and
process that value. It's another to open a form filtered by a particular
value specified by the calling routine. Which of these are you trying to
do?


.