drop-down feeding two fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anon - 31 Jan 2006 05:29 GMT

Oh, how memory fades. I have forgotten how to have a single two-column
drop-down feed two fields.

As I don't want to limit to the list, I can't get away with a join.

Table: Transactions
Field1: Invoice#
Field2: Procedure
Field3: Fee

A drop down that references table Procedures should populate the
corresponding fields in Transactions

Table: Procedures
Field1: Procedure
Field2: Fee

I recall doing this in an Access project about ten years ago and I
recall it being damn easy and not requiring an VB code or Form tricks to
execute.

Reply to this Message

John Mishefske - 31 Jan 2006 06:36 GMT

> Oh, how memory fades. I have forgotten how to have a single two-column
> drop-down feed two fields.
[quoted text clipped - 16 lines]
> recall it being damn easy and not requiring an VB code or Form tricks to
> execute.

Two easy ways to do it. The two fields can be bound to textboxes (hidden or visible)
with their controlsource set to the columns, e.g. Me!cboSomeCombo.Column(1)
This is the pull method.

Or you could use the push method - in the AfterUpdate event of the combo box set
the value of the textboxes.

HTH.

Signature

'---------------
'John Mishefske
'---------------

Reply to this Message