ComboBox

[MacrossHunter77 via AccessMonster.com]

Hello there well I have a question about on how to use the combo box I
already made a combo box in a form to link to a table, now this is a example:

Combobox have this listing from the table
1.Credit
2 Cash
3.Other
I've created a textbox under the combobox wich I named "other"
now here is the expresion that I need in the combobox if I select OTHER I
want to go to the textbox so I can write down the other type of payment at
the same time I want this data store in the table. here is a description for
this:

the first table I used to put all the data from the form I named the table
(Customer) and the form name is (Invoice)

the Second table I named "Type of Payment" the field is "Payment" and the
records 1. Credit, 2. Cash, 3. Other

the Combox box I named "Payment"

and the TextBox is named "other"

please anybody can help me on this I would appreciate

 

[Allen Browne]

Use the Exit (or LostFocus) event procedure of the combo to SetFocus to the
desired control, e.g.:

If Me.Payment = "Other" Then
Me.Other.SetFocus
End If