Combo Box on a Subform

[Joe Cilinceon]

What I have is a temp Table used to accept payments. Now you select a
payment from a combo box. The combo box is based on a lookup table that has
3 fields.

CHARGES
ChgID number
ChgDesc Description of Charge such as Rent
ChgGrp number representing the type of charge.

Now how can I force the ChgGrp in to its fields when I select a charge from
the list. I thinking something like:
Me.ChgGrp = Combo1.[2]

 

[Brendan Reynolds]

Assuming the row source of the combo box selects the three fields in that
order, and the Column Count property of the combo box is set to 3, the code
would be ...

Me.ChgGrp = Me.Combo1.Column(2)

 

[Amy Blankenship]

It sounds like you are making a form to describe different types of charges.
If not, you probably need one.

So you'd have a separate ChgGrp table, and Charges (as a table that
describes categories of charges that are possible) would be on the many side
of a one-to-many relationship. In your form to set up potential charge
types (ChgGrp), you'd have a subform for charges that are in that group.

Then, when you're selecting the charge description, the chargegroup would be
part of the same record, and so you would not need to fill it in, but might
choose to display it on the form...

HTH;

Amy

 

[Joe Cilinceon]

Thanks Brendan that worked perfectly.

Assuming the row source of the combo box selects the three fields in
that order, and the Column Count property of the combo box is set to
3, the code would be ...

Me.ChgGrp = Me.Combo1.Column(2)

 

[Joe Cilinceon]

It sounds like you are making a form to describe different types of
charges. If not, you probably need one.

Actually a Payment Form that allows for selected charges and split payments.

So you'd have a separate ChgGrp table, and Charges (as a table that
describes categories of charges that are possible) would be on the
many side of a one-to-many relationship. In your form to set up
potential charge types (ChgGrp), you'd have a subform for charges
that are in that group.

Yes I have a lookup table for ChgDesc laid out as follows:
ChgID (auto #)
ChgDesc ($)
ChgGrp (#)
ChgDesc ($)

The table that stores the charges on a given transaction is as follows:
Transaction (#)
ChgID
ExplainID (from another lookup table) used for unusal charges

Then, when you're selecting the charge description, the chargegroup
would be part of the same record, and so you would not need to fill
it in, but might choose to display it on the form...

No I don't display it but do use it to locate what is a Credit (overpayment
amount) and what is a balance due.

 

[Joe Cilinceon]

Actually a Payment Form that allows for selected charges and split
payments.

Yes I have a lookup table for ChgDesc laid out as follows:
ChgID (auto #)
ChgDesc ($)
ChgGrp (#)
ChgDesc ($)

Correction here ChgDesc($) is not part of the ChgDesc look up table but is
part of the ChgGroup lookup table. DUH.