Advertisement

05.08.2008 at 03:38PM PDT, ID: 23387940
[x]
Attachment Details

Filter using Combo Box results in Datasheet view

Asked by afsfire in Microsoft Access Database, VB Controls, Microsoft Visual Basic.Net

Tags: , ,

I have a Form (frmSortByLocation) created from a Query (qrySortByLocation).
I have this Combo Box (cboSortByLocation) Which it's Row Source is a table of locations (tblLocation), Example SoCal, NoCal, AZ, NV. the actual code code in the Row Source is SELECT tblLocation.Location FROM tblLocation;

On This form I have a subform (frmSortByLocationSubform)which is a datasheet view. When I select a location from the combo box I want only records with that location to show in my subform. I know it sounds easy but I have been trying everything and for whatever reason it is just not working for me.

Below is the code for the Combo Box...
The Error I get when i select a Location from the Combo box is error 91 object variable or With block variable not set.  What am I doing wrong?Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

Option Compare Database
 
Private Sub cboSortbyLocation_AfterUpdate()
 ' Find the record that matches the control.
    Dim rs As Object
 
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Location] = " & Str(Nz(Me![cboSortbyLocation], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
[+][-]05.08.2008 at 03:44PM PDT, ID: 21529082

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 03:45PM PDT, ID: 21529088

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 03:45PM PDT, ID: 21529093

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.08.2008 at 03:50PM PDT, ID: 21529112

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 03:58PM PDT, ID: 21529144

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 03:59PM PDT, ID: 21529148

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 04:04PM PDT, ID: 21529176

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 04:08PM PDT, ID: 21529196

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 04:14PM PDT, ID: 21529225

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 04:19PM PDT, ID: 21529253

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 04:28PM PDT, ID: 21529308

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 05:18PM PDT, ID: 21529578

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 01:06AM PDT, ID: 21531035

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, VB Controls, Microsoft Visual Basic.Net
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: Sudonim
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.09.2008 at 01:07AM PDT, ID: 21531038

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 01:09AM PDT, ID: 21531045

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 09:13AM PDT, ID: 21534303

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 09:28AM PDT, ID: 21534434

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.12.2008 at 12:30AM PDT, ID: 21545132

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.14.2008 at 10:59AM PDT, ID: 21566892

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628