Auto Update Text box

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

Tom van Stiphout

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
 

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