Set recordsource when combobox clicked ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that finds records in a database. It contains many combo boxes and most of the recordsource's need to query the entire table. Is it possible to invoke the recordsource only when the combo box is clicked rather than invoke them all when the form is opened?

Also how do I make one combo box dependent on another, i.e the selection in one box is to be used in the query of the recordsource for another combo box.

Thanks in advance.
 
Hi,

I'm not quite sure about your question:
"Is it possible to invoke the recordsource only when the combo box is
clicked rather than invoke them all when the form is opened?"

By default the recordsource is only requeried when you click the combo box.

In answer to your other question:
"Also how do I make one combo box dependent on another"

See:
ACC2000: How to Create Synchronized Combo Boxes
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Set recordsource when combobox clicked ?
| thread-index: AcQN3N1qfSMb04CRRoq6pcvm+Q8zcQ==
| X-Tomcat-NG: microsoft.public.access.formscoding
| From: "=?Utf-8?B?RGF2aWQ=?=" <[email protected]>
| Subject: Set recordsource when combobox clicked ?
| Date: Fri, 19 Mar 2004 10:06:13 -0800
| Lines: 5
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.formscoding
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.formscoding:225349
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| I have a form that finds records in a database. It contains many combo
boxes and most of the recordsource's need to query the entire table. Is it
possible to invoke the recordsource only when the combo box is clicked
rather than invoke them all when the form is opened?

Also how do I make one combo box dependent on another, i.e the selection in
one box is to be used in the query of the recordsource for another combo
box.

Thanks in advance.
|
 
Back
Top