autofilling fields, when choosing selection from combo box

  • Thread starter Thread starter Guest
  • Start date Start date
hi,
could use a little more info but...
this could be done with an if then else statement in the
combo box change event.
if combobox1 = "something" then
textbox1 = "this"
textbox2 = "that"
else
if combox1 = "something else" then
textbox1 = "whatever"
textbox2 = "wahtever2"
end if
end if
vague i know but without more info that is about as
specific as i can get.
hope it helped.
 
Ex: In form view, I need to choose an entry from a field combo box which is
related to 2 additional fields from the same query.

I would like to have the following fields automatically fill the
([Campaign#] and [Reunion#]) fields based on the choice from the
[EventDescrip] combo box, which is a look up query in the main table. These
fields must display the number assigned not the [EventDescrip] in the form
and the report or at least the report. The look up query consists of 3
fields the Reunion#, Campaign# and EventDescrip.

Thank you for any help you can give.
 
Back
Top