Populating Unbound Objects

[CharlieT302]

Hi folks,

I have an unbound combo box which extracts a company name using a relational query (in the form of an SQL statment in the RowSource).

It's fine. However, I have two other unbound fields: one for phone and one for fax. Both values can be obtained from the same query above.

When I select a company, I would like Access to populate the Phone and Fax fields (unbound) with the correct numbers.

How can this be done?

Thanks

 

[Eupher]

Hi, CharlieT,

Use column notation. For instance, in the AfterUpdate event of the combo, you could do something like this:

Private Sub MyCombo_AfterUpdate()
    Me!MyPhoneNumber = Me!MyCombo.[blue]Column([/blue][red]x[/red])
    Me!MyFaxNumber = Me!MyCombo.[blue]Column([/blue][red]y[/red])
End Sub

...where [red]x[/red] and [red]y[/red] represent the appropriate columns in your combo's SQL. Column notation is zero-based, so the first column is 0, 2nd column is 1, etc.

HTH,

Ken S.

 

[CharlieT302]

That was great. Thanks much.