Help with connecting boxes

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

Is it possible to make my form so that when my people
select what class people are paying for from a drop down
combo box that it will just place the correct account
number into another combo box. As of now, they selct the
class the customers are paying for and then they have to
type in the corresponding account number. I do have a
table that contains enough entries that I could use some
type of querie to do it but I dont know how. PLease help.
 
Jesse,

Set the combo box's RowSource property to a query that includes both the
account number and price. Then in the combo's AfterUpdate event, use
something like the following to transfer the price from the combo to a
textbox.

If Nz(Me.cboClass, 0) > 0 Then
Me.txtPrice = Me.cboClass.Column(2)
End If

Change the control names to match the one's you have, and change the column
number to reflect the actual column you use in your combo box, remembering
that the first column in a combo is zero.

Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Is it possible to make my form so that when my people
select what class people are paying for from a drop down
combo box that it will just place the correct account
number into another combo box. As of now, they selct the
class the customers are paying for and then they have to
type in the corresponding account number. I do have a
table that contains enough entries that I could use some
type of querie to do it but I dont know how. PLease help.
Click to expand...

How are the identity of the class and of the corresponding account
related? Does each class have its own account, or might one class have
several accounts, or might each account cover several classes?
 
Back
Top