Automatic Population of fields

[morydd]

I've got a budgeting database, and when entering expenses, the user has
an option of payment type (credit card, cash, PO) if the user selects
PO, they have to enter the PO number from a drop down.
Since PO's are assigned to a specific supplier, I'd like the supplier
field (currently a drop-down) to be automatically populated when the PO
number is selected. But that field need to be filled manually for
credit card or cash purchases.

Any suggestions would be appreciated.

--
Sean T. Evans

[Russell Sinclair]

If you're using a drop-down, you can add the supplier as a second,
hidden column, then pass the text on to the supplier drop-down.

Basically, setup the PO drop-down to include the Supplier ID (or name
if that's what's in the supplier drop-down). When the user selects a PO
- in the AfterUpdate event add some code to pass the second column of
the drop-down to the other drop-down. E.G.:

cboSupplier = cboPO.Column(1)

Lemme know if you need more info.

Russell Sinclair

[morydd]

I'm not sure where I've messed up, but here's what I've got

Private Sub PO_Drop_AfterUpdate()
Me.Supplier_ID = Me.PO_Drop.Column(5)
End Sub

The PO_Drop combo box is pulled from a query that gets:
PO_ID, PO_Number, Supplier_Name, Account_Name, Supplier_ID, Account_ID

I couldn't understand where cboSupplier... went, I tried it in the
AfterUpdate option of properties, but that didn't seem to work. It
seemed to think that was a macro.

I'm not getting any kind of error message, just not getting any change
in the Supplier_ID combo box.

Thanks for the help thus far.

[Bob Quintal]

"morydd" <se********@americangirl.com> wrote in
news:11**********************@o13g2000cwo.googlegr oups.com:

I'm not sure where I've messed up, but here's what I've got

Private Sub PO_Drop_AfterUpdate()
Me.Supplier_ID = Me.PO_Drop.Column(5)
End Sub

The PO_Drop combo box is pulled from a query that gets:
PO_ID, PO_Number, Supplier_Name, Account_Name, Supplier_ID,
Account_ID

I couldn't understand where cboSupplier... went, I tried it in
the AfterUpdate option of properties, but that didn't seem to
work. It seemed to think that was a macro.

I'm not getting any kind of error message, just not getting
any change in the Supplier_ID combo box.

Thanks for the help thus far.

Since the column() count is Zero-based, you are updating with the
Account_id. Try Me.Supplier_ID = Me.PO_Drop.Column(4)

--
Bob Quintal

PA is y I've altered my email address.

[morydd]

It's always the little things that get you. Thanks for the reminder. It
seems to work like a charm now.