Combo Box choice to change a option in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database that has a combo box. In that combo box i have 4
choices for someone to select. These choices are called type.
In the bottom of the database i have a text box that i want to put a certain
name in that box when a certain type is chosen from the combo box.
I am currently using the onchange event.
The code looks like below
Private sub type_change()
if type = "SAVE" then
scent9 = "SAVE"
else
Scent9 = "APPLE"
end if
end sub

DOes anyone have any suggestions of how to get this to change. I know it
will be something very simple, but it has been bugging me for days.

thanks JR
 
Back
Top