467,161 Members | 1,016 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Fill from Combo Box Selection - Speed Issue?

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
Nov 13 '05 #1
  • viewed: 1745
Share:
1 Reply
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Sherwood Botsford | last post: by
3 posts views Thread by Antoine Janssen | last post: by
1 post views Thread by peasedm@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.