Auto Update Text box

  • Thread starter Thread starter MWDAN
  • Start date Start date
M

MWDAN

Hello,

I'm building my first ever Access datebase and I have a form called Enter
Comp. In this form I have a combo box called Combo9 that gets it's data from
a table called CompType. In the Table CompType I have three fields. The Comp9
combo box gets it data for the second field in the table the field is called
Compdescription. On the form Enter Comp I also have a text box called
CompAmount. I want this text box to auto populate once a user choices a
comptype from the Combo9 combo box with the number that is in the Points
table on the CompType table. Currently on the CompType table the fist filed
is called ComptypeID this number starts at 1 and auto counts to the next
number. So like on the table ComptypeID is 1, CompDescription is Buffet and
Points is 200. So again what I'm looking for is when a user selects the
Buffet on the Combo9 combo box on the form the text box CompAmount auto
updats to 200. I hope this makes scense.
 
On Sun, 31 Jan 2010 15:51:01 -0800, MWDAN

I am assuming your dropdown already has all 3 columns from CompTypes.
You may choose to display the Points or not.
Then in the Points textbox set the ControlSource to:
=cboCompType.Column(2)
(notice how I renamed the combobox with a descriptive name)

Now here is the rub: in most database designs Points does not belong
in the tblComps table. This is because given a CompTypeID it can be
looked up in tblCompTypes. If you already designed your db: good for
you!

-Tom.
Microsoft Access MVP
 
Back
Top