Combo Boxes on Forms

  • Thread starter Thread starter Michael Comtois
  • Start date Start date
M

Michael Comtois

I am using access 2002 on a Windows XP machine.
Basically what I'm attempting to do is to improve
efficiency in filling out a form by having combo boxes
instead of typing in the name everytime. The challenge
is that I want the list to shorten because of values I
put in another box. For example, there are a number of
different customer numbers (Cust#), and for each there is
a number of different customer names (CustName), what I
want to be able to do is to type in the Cust# and then
have the CustName combo box only hold those CustNames
that go with the Cust#. Then I want the CustName to
shorten down the combo box which contains the name of who
it was requested by (ReqBy), and when the name of the
person in ReqBy is chosen, I want thier phone number to
automatically fill in. This may sound confusing, but I'm
hoping it is possible.

So basically:

Cust# yeilds CustNames yeilds ReqBy yeilds Phone Number.

Thank you for any help I can get!!

Michael Comtois
First American
 
Michael Comtois said:
I am using access 2002 on a Windows XP machine.
Basically what I'm attempting to do is to improve
efficiency in filling out a form by having combo boxes
instead of typing in the name everytime. The challenge
is that I want the list to shorten because of values I
put in another box. For example, there are a number of
different customer numbers (Cust#), and for each there is
a number of different customer names (CustName), what I
want to be able to do is to type in the Cust# and then
have the CustName combo box only hold those CustNames
that go with the Cust#. Then I want the CustName to
shorten down the combo box which contains the name of who
it was requested by (ReqBy), and when the name of the
person in ReqBy is chosen, I want thier phone number to
automatically fill in. This may sound confusing, but I'm
hoping it is possible.

So basically:

Cust# yeilds CustNames yeilds ReqBy yeilds Phone Number.

Thank you for any help I can get!!

Michael Comtois
First American
Click to expand...

This page from the Access Web shows two ways to do it:

http://www.mvps.org/access/forms/frm0028.htm

Note that there are two distinct methods on the page. The second begins
after the first block of example code.
 
Michael Comtois said:
Unfortunately I cannot get this to work still. Any other
ideas??
Click to expand...


That's the way to do it, though. Please show your code, describe the
relevant properties of the combo boxes, and tell in what way it isn't
working. Then maybe we can tell you how to fix it.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


 
Back
Top