ComboBox?

[T588]

I have a form with a combobox (Customer) that controls info in 3 text boxes (address, city ect)

I added another combobox (company) above the first and want this to control the same textboxes

all info is in same (table) and same source row (query).

I would like:

If user picks company it pulls all info: ie: customer, address ect

If customer pulls all info: ie: Company, address ect

How would I do This?

Vince

 

[T588]

I might add that I allready have the customer setup and working
just not sure how to add the source for the new company combobox.

Vince

 

[T588]

Explained further…………………

Below is how I currently have the text boxes linked to the “SoldtoCustomer” ComboBox
-The information is retrieved from the query also listed below.



“Address textbox”- =[SoldtoCustomer].Column(2)

“City textbox” - =[SoldtoCustomer].Column(3)

“State textbox”- =[SoldtoCustomer].Column(4)

“Zip textbox” - =[SoldtoCustomer].Column(5)


SELECT [Customers].[ID], [Customers].[CustomerName], [Customers].[Address], [Customers].[City], [Customers].[State], [Customers].[Zip] FROM Customers;

****************************************************

With the addition of another ComboBox (SoldtoCompany)
and another column (CompanyName)
(unmodified textbox control)

“Address textbox”- =[SoldtoCustomer].Column(3)

“City textbox” - =[SoldtoCustomer].Column(4)

“State textbox”- =[SoldtoCustomer].Column(5)

“Zip textbox” - =[SoldtoCustomer].Column(6)

SELECT [Customers].[ID], [Customers].[CompanyName], [Customers].[CustomerName], [Customers].[Address], [Customers].[City], [Customers].[State], [Customers].[Zip] FROM Customers;


Is it possible to have the same textboxes linked to 2 separate comboboxes?
In the above example: how can I modify “[SoldtoCustomer]” to include “SoldtoCompany” so the textboxes display info from either combobox? Is it possible

Vince

 

[T588]

This procedure might be possible in VB - has anyone had experience completing this task in code? Does anyone know where I might find a good example? Suggestion of where I might
look for an example?

Vince

 

[WayneRyan]

Vince,

Use the search facility here and look for "Cascading combo"

Wayne

 

[T588]

Thanks -I didn't know what that particular procedure was called.
Vince

 

[T588]

This wasn't quite what I was looking for.......But I may be left with no other option.

What I was looking for is :

ComboBox -"A"
ComboBox -"B"
TextBox - "C"
TextBox - "D"
TextBox - "E"
TextBox - "F"

upon selecting value in combobox "A" :
Combobox "B" filled
TextBox - "C" filled
TextBox - "D" filled
TextBox - "E" filled
TextBox - "F" filled
without any further user input
**************************
upon selecting value in combobox "B" :
Combobox "A" filled
TextBox - "C" filled
TextBox - "D" filled
TextBox - "E" filled
TextBox - "F" filled

without any further user input

Vince