Combo Box Problem - simple solution I hope?

[Johnrg]

I have a form for entering new customer details.

There are three fields in this form called Country, Region and CountryPrefixCode that require standard information.

I have created a combo box in the Country field that looks at a table called Currencytypes for its row source

The table Currencytypes has the following five fields:

CurrencyID (primary key)
Country
Region
CountryPrefixCode
CurrencyType

Basically, I want the Region and Country prefix codes to be automatically looked up and automatically entered into the form when I choose the desired Country from the combo box.

Can anyone give me a step by step on this? I read the manual but it only offers examples based on two tables and a one-to-many relationship and a query.

Thanks

JG

 

[John Big Booty]

Have a search on Cascading Combo Boxes on this forum or check out the examples here

 

[Johnrg]

Hi there,
I looked at the examples but I am not sure if that's what I want.
I'm looking for auto look up and entry, not filtering?
Maybe I'm just confused?
JG

 

[John Big Booty]

As part of your combo have the underlying query select all the additional info associated with the county. This would not need to be displayed in the combo, ie. the column width could be set to 0Cm.

Then in the control source of a text box put;

=CombName.Column(x)

where x corresponds to the column in the combo you wish to display. Remember that the columns are numbered from zero up.

 

[Johnrg]

Thanks for that,
I got that all loaded up and and it works fine putting the data auto into the correct places.
The only issue is when I go to save the record I get a prompt saying that the "required field is set to true and I can't enter a null value"
whats that about
JG

 

[John Big Booty]

Any chance of posting a copy of the DB, and I'll have a look at it.