List box parameter problem

[janetb]

Have a parent form (frmWebEvent) that loads a specific event based on a key
field (zEID). I have two list box controls on the form that need the be
restricted to reflecting just those items based on the key. When I specify
zEID=[forms]![frmWebEvent]![zEID] in the list box row source to limit the
reflected rows, I then get a parameter prompt upon closing of the form
frmWebEvent requesting the paramter for [forms]![frmWebEvent]!zEID. It
doesn't matter which list box I place the criteria into - either will produce
the prompt. I've done this on other forms, but is there something I'm
missing? (In fact, this form is almost a duplicate of a form for non-web
events and that form has almost idential list boxes with the same criteria
and no problems.) I've tried deleting and recreating the form, but it always
hangs at this point. Subforms seems to be okay. But, I need to open another
form based on the click event in the list box, so I'd really like to keep the
list boxes.

There are no other functions on the form running inteference at this point.

Any help appreciated.

jb

 

[Amy Blankenship]

I suspect the problem is not that it' not working correctly in the
listboxes, but that the next thing you want to do, open another form,
depends on the value you've entered in the listboxes which are now gone.
Try just hiding the form on close, opening the other form, then closing the
form from the now-open other form.

HTH;

Amy

 

[janetb]

Amy,
Many thanks - my fault for stating it badly.
When I close the form frmWebEvent, no other forms appear as a result of the
value in the list box. I don't need the forms referenced by the list box to
open. That only happens when I click on the list box (which I haven't even
put back in at this point) and that form is on top and the current form. All
I want to do is close the frmWebEvent.

Better?
Janet

I suspect the problem is not that it' not working correctly in the
listboxes, but that the next thing you want to do, open another form,
depends on the value you've entered in the listboxes which are now gone.
Try just hiding the form on close, opening the other form, then closing the
form from the now-open other form.

HTH;

Amy

Have a parent form (frmWebEvent) that loads a specific event based on a
key
field (zEID). I have two list box controls on the form that need the be
restricted to reflecting just those items based on the key. When I
specify
zEID=[forms]![frmWebEvent]![zEID] in the list box row source to limit the
reflected rows, I then get a parameter prompt upon closing of the form
frmWebEvent requesting the paramter for [forms]![frmWebEvent]!zEID. It
doesn't matter which list box I place the criteria into - either will
produce
the prompt. I've done this on other forms, but is there something I'm
missing? (In fact, this form is almost a duplicate of a form for non-web
events and that form has almost idential list boxes with the same criteria
and no problems.) I've tried deleting and recreating the form, but it
always
hangs at this point. Subforms seems to be okay. But, I need to open
another
form based on the click event in the list box, so I'd really like to keep
the
list boxes.

There are no other functions on the form running inteference at this
point.

Any help appreciated.

jb

 

[Amy Blankenship]

I've found before that when things like this happened it was because the
control wasn't called what I thought it was.

HTH;

Amy

Amy,
Many thanks - my fault for stating it badly.
When I close the form frmWebEvent, no other forms appear as a result of
the
value in the list box. I don't need the forms referenced by the list box
to
open. That only happens when I click on the list box (which I haven't
even
put back in at this point) and that form is on top and the current form.
All
I want to do is close the frmWebEvent.

Better?
Janet

I suspect the problem is not that it' not working correctly in the
listboxes, but that the next thing you want to do, open another form,
depends on the value you've entered in the listboxes which are now gone.
Try just hiding the form on close, opening the other form, then closing
the
form from the now-open other form.

HTH;

Amy

Have a parent form (frmWebEvent) that loads a specific event based on a
key
field (zEID). I have two list box controls on the form that need the
be
restricted to reflecting just those items based on the key. When I
specify
zEID=[forms]![frmWebEvent]![zEID] in the list box row source to limit
the
reflected rows, I then get a parameter prompt upon closing of the form
frmWebEvent requesting the paramter for [forms]![frmWebEvent]!zEID. It
doesn't matter which list box I place the criteria into - either will
produce
the prompt. I've done this on other forms, but is there something I'm
missing? (In fact, this form is almost a duplicate of a form for
non-web
events and that form has almost idential list boxes with the same
criteria
and no problems.) I've tried deleting and recreating the form, but it
always
hangs at this point. Subforms seems to be okay. But, I need to open
another
form based on the click event in the list box, so I'd really like to
keep
the
list boxes.

There are no other functions on the form running inteference at this
point.

Any help appreciated.

jb

 

[janetb]

Amy,
Well, to test your theory, I compacted and repaired the database. Then, I
created a brand new control from the toolbar and named it george with a
control source of zEID. I then limited the list control's row source
property to forms!frmWebEvent!george. Form frmWebEvent opens great, list box
is limited to the correct records. But, when I close the form frmWebEvent, I
am prompted for a parameter for forms!frmWebEvent!george

Anybody got any ideas?

Amy,
Many thanks - my fault for stating it badly.
When I close the form frmWebEvent, no other forms appear as a result of the
value in the list box. I don't need the forms referenced by the list box to
open. That only happens when I click on the list box (which I haven't even
put back in at this point) and that form is on top and the current form. All
I want to do is close the frmWebEvent.

Better?
Janet

I suspect the problem is not that it' not working correctly in the
listboxes, but that the next thing you want to do, open another form,
depends on the value you've entered in the listboxes which are now gone.
Try just hiding the form on close, opening the other form, then closing the
form from the now-open other form.

HTH;

Amy

Have a parent form (frmWebEvent) that loads a specific event based on a
key
field (zEID). I have two list box controls on the form that need the be
restricted to reflecting just those items based on the key. When I
specify
zEID=[forms]![frmWebEvent]![zEID] in the list box row source to limit the
reflected rows, I then get a parameter prompt upon closing of the form
frmWebEvent requesting the paramter for [forms]![frmWebEvent]!zEID. It
doesn't matter which list box I place the criteria into - either will
produce
the prompt. I've done this on other forms, but is there something I'm
missing? (In fact, this form is almost a duplicate of a form for non-web
events and that form has almost idential list boxes with the same criteria
and no problems.) I've tried deleting and recreating the form, but it
always
hangs at this point. Subforms seems to be okay. But, I need to open
another
form based on the click event in the list box, so I'd really like to keep
the
list boxes.

There are no other functions on the form running inteference at this
point.

Any help appreciated.

jb