main form - with subform

  • Thread starter Thread starter Revned
  • Start date Start date
R

Revned

i have a my main form with a subform bound in a table
that table has combo box display control

i want to tell access let say that when I choose record from this column it
also
displays the item discription to Item Description column and the price to
Price column, in my main form subform. i am using access 2003. is it possible?

thanks for any help? if code is necessary pls help me too

thanks again
 
Revned,
Not sure what you mean by...
... when I choose record from this column it...
Click to expand...
I think you mean... when I select a value in the combo box.

As you have not provided any information as to control names,
and combo columns, I'll use my own.

I'm going to assume that your combobox (ex. cboPartNo) allows
the user to select a unique value, like a PartNo.
I'll also assume that there are 3 columns in this combo...
PartNo PartDescription PartPrice

PartPrice should be saved to your table, as it may change in the future.
But, there's no need to save the Description, as that should not change
in the future, and can always be reassociated to the PartNo whenever needed.

Using the AfterUpdate event of cboPartNo send the PartPrice value to the
PartPrice control...
PartPrice = cboPartNo.Column(2)
(combo box columns, left to right, are numbered 0, 1, 2, 3, etc...)

In the Description control, give it a ControlSource of...
=cboPartNo.Column(1)
and it will always display the associated Description... but will not save
it to the table.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top