1 selection updates multiple controls

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I have a cutsomer form (underlaying table 'customers').
I have a subform called Order (data source is a
table 'order details' - which is related to customers
via 'customerID'), it is a multi tabbed form containing
order details. I want the user to be able to enter a
product selected from a combo box, then I want a text box
next to it to automatically be filled in with the price
(which is stored in the products table). My question is
how do you make one selection on a form update 1 or more
controls? I suspect I need to use the onUpdate of the
combo box...but I can't figure out how to set the value
of a control equal to the second or third column of the
combo box. I'm sure there must be a simple
solution...any help is appreciated.

I am also having a problem with copy and paste append on
my tabbed subform. I have a button called re-order that
copies the whole order into a blank record under the same
customer (and it changes all date fields to blank - i.e.
order date, due date etc.), but sometimes it works and
sometimes I get a paste append error and I can't figure
out what is going on.
Does access just not like copy and paste when there are
tabbed forms involved?

Thanks
 
Ok..Since I posted, I have seen the comments
about "pushing" the value of a second column into a
field...works great. but still have problems with second
issue of copy/append. Thanks
 
Back
Top