Combo Box on Form

[Ellen Leonard]

My users want a combo box which lists area code, time zone, state, country so
they can select a time zone to be put on the Customer Information Form.

I created a table named TimeZone for this purpose as a lookup table.
I created a field in the Customer table called time zone (text field).

On the form I created a combo box and based in on a query of the Time Zone
table to show the four fields.
It is bound on Column 1 (area code) (which is what the user wants to search
on)

The problem is how do I get the time zone value to fill in on Customer rather
than the area code?

Thanks,

Ellen Leonard

 

[fredg]

My users want a combo box which lists area code, time zone, state, country so
they can select a time zone to be put on the Customer Information Form.

I created a table named TimeZone for this purpose as a lookup table.
I created a field in the Customer table called time zone (text field).

On the form I created a combo box and based in on a query of the Time Zone
table to show the four fields.
It is bound on Column 1 (area code) (which is what the user wants to search
on)

The problem is how do I get the time zone value to fill in on Customer rather
than the area code?

Thanks,

Ellen Leonard

If your Time Zone column is the Combo box 2nd column, then
Code the Combo Box AfterUpdate event:

[TimeZone] =Me!ComboName.Column(1)

Combo boxes are 0 based, so Column(1) is the 2nd column.
Adjust the above code accordingly.

 

[Ellen Leonard via AccessMonster.com]

Thank you so much... works like a dream.

My users want a combo box which lists area code, time zone, state, country so
they can select a time zone to be put on the Customer Information Form.

[quoted text clipped - 13 lines]

Ellen Leonard

If your Time Zone column is the Combo box 2nd column, then
Code the Combo Box AfterUpdate event:

[TimeZone] =Me!ComboName.Column(1)

Combo boxes are 0 based, so Column(1) is the 2nd column.
Adjust the above code accordingly.