ListBox Selector

D

DS

I'm going crazy here. I'm trying to set up a listbox where the user
clicks on a particular item in the listbox and a form open up. Every
item would have a different form popping up for it. The problem seems
to be that no matter what item you choose or wheveryou click in the
listbox the same form pops up! How can I remedy this? Thanks
DS
 
D

DS

Wayne said:
What is the code you are using to open the pop-up form?
Click to expand...
OK, I'm getting closer. I think what I need is a Where ststement. I'm
using a Macro to open the form, So I need a Where Statement refering to
the Listbox. Howdoes one do that? Then...I needto send the selection
to another field. Heres what I'm ultimatly trying to do...Have you ever
seen a restaurant order screen? Where you have an Order Screen, You
click on it..a modifier screen pops up then the selection goes to an on
screen check... which I presume has an order detail attached to it. Any
help that you can offer I would sincerely appreciate.
Thank You
DS
 
W

Wayne Morgan

In the bottom part of the macro design window, when you have the OpenForm
action row selected on the top part, there is a Where box. You can refer to
the control on the form from there to filter the form you're opening. It
would look something like:

[FieldName]=Forms!MyForm!MyControl
 
Top