By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Form List Box

P: n/a
Hi All,
I have a List Box on a form. The values in the list box need to be variable
based on another field value (text box) on the form. How can this be done.

Each time I try, the values are set once (when the form is opened) and not
reset when the value of the text box changes.

Thanks!!!
Paula
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Requery the list box in the AfterUpdate event of the text box.

Pavel

Irwinsp wrote:

Hi All,
I have a List Box on a form. The values in the list box need to be variable
based on another field value (text box) on the form. How can this be done.

Each time I try, the values are set once (when the form is opened) and not
reset when the value of the text box changes.

Thanks!!!
Paula

Nov 12 '05 #2

P: n/a
ir*****@aol.com (Irwinsp) wrote in message news:<20***************************@mb-m01.aol.com>...
Hi All,
I have a List Box on a form. The values in the list box need to be variable
based on another field value (text box) on the form. How can this be done.

Each time I try, the values are set once (when the form is opened) and not
reset when the value of the text box changes.

Thanks!!!
Paula


You have to force the requery of the listbox in the Exit or whatever
event of your textbox or the focus event of your listbox.
Nov 12 '05 #3

P: n/a
Thanks for the help. It is working!
Nov 12 '05 #4

P: n/a
Thanks for the help!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.