form combo box

[macamarr]

Hi, & thanks for looking,

On my form I currently have a combo box that populates my Account description textbox. Is it possible to have it populate my account number text box too?

 

[SydneyGeek]

Yes -- in fact, you can push every column in the data set of a combo box out to a different control. Here's how:

1. In the Properties for the Combo, select the RowSource row and hit the Builder (...) button to get the query grid. Let's say you build the query so you have the ID field first, then 3 other fields -- Field1, Field2, Field3. Close, save when prompted, and adjust the Column Count to match the no of fields in the query (4 for this example).

2. Click the Events tab, find the AfterUpdate event, click in there and hit the Builder button. If prompted for choices, slect Code and OK. In the code, put this:
[TextBox1] = [MyComboName].Column(1)
[TextBox2] = [MyComboName].Column(2)
etc.

Note: Column(1) is the SECOND field in the ComboBox query because the combo (and ListBox) columns are zero-indexed (0,1,2,3...)

Now, picking an item in the Combo should push the required data out to TxtBox1, 2, 3...

HTH

Denis