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