ComboBox source query: run at Form_Open

Jean

Hi,

I think this is quite a simple one:

I have a ComboBox, where the source is a stored query. When I click the
drop-down arrow on the Box, it takes awhile. I want to run this query
in the background when the form opens, so that when I click the
dropdown, it is ready.

How?

Thanks, really appreciate it.

J

Nov 13 '05 #1

Subscribe Post Reply

1892

Larry Linson

As far as I know, what you propose will not speed up your combo box at all,
and in fact will slow your overall operation, because the ComboBox will run
its Row Source query when it is initialized, whether or not that query has
already been executed.

Larry Linson
Microsoft Access MVP
"Jean" <je**********@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hi,

I think this is quite a simple one:

I have a ComboBox, where the source is a stored query. When I click the
drop-down arrow on the Box, it takes awhile. I want to run this query
in the background when the form opens, so that when I click the
dropdown, it is ready.

How?

Thanks, really appreciate it.

J

Nov 13 '05 #2

Similar topics

Odd Behavior Of Combobox and Textbox

by: Steve | last post by:

I have an unbound combobox in the form header of a continuous form. The selection in the combobox sets the where clause in a querydef which determines QryPFrmInventoryManagement. The following code...

Microsoft Access / VBA

Changing rowsource when dropdown the combobox

by: Nicolae Fieraru | last post by:

Hi All, I am trying to change the rowsource of a combobox when I click on it. I played with many events, associated with the form and the combobox, but still haven't figured out what is the way...

Microsoft Access / VBA

Access re-writes combobox row source query

by: weitzag | last post by:

I have a combobox on a form with the following row source SQL query. SELECT tblSupplyType.SupplyName, tblSupplyType.PWS_ID FROM tblSupplyType WHERE...

Microsoft Access / VBA

Criteria For Subform Combobox Rowsource

by: Tom | last post by:

I have the following tables: TblState StateID State TblCounty CountyID StateID County

Microsoft Access / VBA

problem binding comboBox to dataset

by: Omar | last post by:

When I try to databind my comboBox (specifically field "emplcode") to a filled dataset , the contents of the comboBox displays a bunch of "System.Data.DataRowView". I assume the amount of times...

C# / C Sharp

Order records in ComboBox

by: Georges Heinesch | last post by:

Hi. I have a ComboBox in a table (tbl1), which is populated by another table (tbl2). The ComboBox "Row Source Type" is set to "Table/Query", and the "Row Source" is set to "tbl2". In this...

Microsoft Access / VBA

Limit field values with a combobox on a subform

by: svdoerga | last post by:

Hello! I have a question I've been working on for a few days now and I can't find a solution. I hope there is someone that has the answer :) I'm using Access 2003 in win XP. I have a main form...

Microsoft Access / VBA

Can't see combobox values in table lookup

by: Mark | last post by:

I have a table with a field that uses a combobox to populate values. The Lookup tab within table design mode is the following: Display Control Combo Box Row Source Type ...

Microsoft Access / VBA

Combobox does not show the correct value

by: AccessBeetle | last post by:

Private Sub Form_Open(Cancel As Integer) Combo34.SetFocus If DLookup("", "RadioLog_tblValUsers", "= '" & !! & "'") = "mngr" Then If DLookup("", "RadioLog_tblValUsers", "= '" & !! & "'") = 1...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing