Fill from Combo Box Selection - Speed Issue?

[Tom G]

Hello,

I need some advice on which way to resolve the following. On a form, the
user will make a selection from a combo box, after the selection several
different fields need to be updated on the form, based on the selection in
the combo box.

I have been doing this quite successfully by having the combo box rowsource
query contain all the fields and simply use the correct column to fill in
the text boxes. e.g. me.txtState = me.cboSelection.column(2)

My question? I now need to populate 12 fields, which will bring the columns
in my rowsource query to 14. Is this query too big for this technique and
should I shorten the query to just get an ID, and use code to fill in the
fields based on creating a recordset?

Also, the combo box rows will typically be under 100, no more than a
thousand.

I'm just looking for others experiences or opinions on this, any thoughts?

Thanks!
Tom

[Matthew Wells]

I often uses something similar. I fill the combo box the same way, but
instead of using code to populate the other fields, I set the other fields'
control source property to =[Salesperson].column(9)

This seems to be much faster. I haven't had a performance issue so far.

Matthew Wells
MW****@FirstByte.net

"Tom G" <no****@none.com> wrote in message
news:Nc******************@tornado.rdc-kc.rr.com...

Hello,

I need some advice on which way to resolve the following. On a form, the
user will make a selection from a combo box, after the selection several
different fields need to be updated on the form, based on the selection in
the combo box.

I have been doing this quite successfully by having the combo box rowsource query contain all the fields and simply use the correct column to fill in
the text boxes. e.g. me.txtState = me.cboSelection.column(2)

My question? I now need to populate 12 fields, which will bring the columns in my rowsource query to 14. Is this query too big for this technique and
should I shorten the query to just get an ID, and use code to fill in the
fields based on creating a recordset?

Also, the combo box rows will typically be under 100, no more than a
thousand.

I'm just looking for others experiences or opinions on this, any thoughts?

Thanks!
Tom