By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

Fill from Combo Box Selection - Speed Issue?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.