autofilling fields, when choosing selection from combo box

G

Guest

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.
 
S

Schar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top