After filter, can't navigate

[gmazza via AccessMonster.com]

Hey there,
I have a form and subform and 6 combo boxes on the main form and the results
get filtered with the appropriate record showing up in the subform. Here's
the problem:
When I open the form it shows ALL records and I can navigate fine. When I
choose any combo box and the subform gets filtered, I can't navigate to any
of the records anymore. It just sits on the 1st record.
Any ideas?
Thanks!

 

[Klatuu]

How many records in the recordset?
Sounds like you have only 1.

 

[gmazza via AccessMonster.com]

The subform is based on a query from 5 tables and the total records are 13.
When I first open the form, all 13 records show and I can navigate to each
record.
When I choose a combo box and filter the form, then there are fewer records
showing from the 13 as I have it now filtered from the result of the combo
box. Now I can't navigate. Its always after a choice from the combo. Thanks!

How many records in the recordset?
Sounds like you have only 1.

Hey there,
I have a form and subform and 6 combo boxes on the main form and the results

[quoted text clipped - 5 lines]

Any ideas?
Thanks!

 

[Klatuu]

Can you clear this up a bit for me, please.
Are the 13 records in the subform or the main form?
Is the subform a single form, a datasheet, or a continuous form?
What is in the subform?
Where are the combos?
Are the combos filtering the main form or the sub form?
Which form are you trying to navigate?
--
Dave Hargis, Microsoft Access MVP

The subform is based on a query from 5 tables and the total records are 13.
When I first open the form, all 13 records show and I can navigate to each
record.
When I choose a combo box and filter the form, then there are fewer records
showing from the 13 as I have it now filtered from the result of the combo
box. Now I can't navigate. Its always after a choice from the combo. Thanks!

How many records in the recordset?
Sounds like you have only 1.

Hey there,
I have a form and subform and 6 combo boxes on the main form and the results

[quoted text clipped - 5 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

Sure, no prob!
The 13 records are in the subform.
Subform is continuous.
There are 5 text fields in the subform
The combos are on the main form.
The combos are filtering the sub form, the main form has no Recordsource.
The navigation buttons I am trying to use are on the subform, not main form.
Hope that helps!

Can you clear this up a bit for me, please.
Are the 13 records in the subform or the main form?
Is the subform a single form, a datasheet, or a continuous form?
What is in the subform?
Where are the combos?
Are the combos filtering the main form or the sub form?
Which form are you trying to navigate?

The subform is based on a query from 5 tables and the total records are 13.
When I first open the form, all 13 records show and I can navigate to each

[quoted text clipped - 10 lines]

 

[KARL DEWEY]

I do believe you are missing the idea of a filter. Of the 13 orignal
records only 5 get through the filter. So that is all you get.

A filter is not a sorting and pointing tool.

Is that what you want? A process that groups those 5 records, moves the
focus to one of them and allows viewing the other 8 when you scroll past the
filtered 5?

--
Build a little, test a little.

Sure, no prob!
The 13 records are in the subform.
Subform is continuous.
There are 5 text fields in the subform
The combos are on the main form.
The combos are filtering the sub form, the main form has no Recordsource.
The navigation buttons I am trying to use are on the subform, not main form.
Hope that helps!

Can you clear this up a bit for me, please.
Are the 13 records in the subform or the main form?
Is the subform a single form, a datasheet, or a continuous form?
What is in the subform?
Where are the combos?
Are the combos filtering the main form or the sub form?
Which form are you trying to navigate?

The subform is based on a query from 5 tables and the total records are 13.
When I first open the form, all 13 records show and I can navigate to each

[quoted text clipped - 10 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

Ok so 5 get through the filter. I don't want to see the other 8 records. I
just want to be able to navigate through the 5 there. Reason is I have a
hyperlink field on the form for each record. So If I choose a combo, then 5
records show up, I want to be able lets say to goto the 3rd record's
Hyperlinked field and click on it to open a folder on my hard drive.

I do believe you are missing the idea of a filter. Of the 13 orignal
records only 5 get through the filter. So that is all you get.

A filter is not a sorting and pointing tool.

Is that what you want? A process that groups those 5 records, moves the
focus to one of them and allows viewing the other 8 when you scroll past the
filtered 5?

Sure, no prob!
The 13 records are in the subform.

[quoted text clipped - 17 lines]

 

[KARL DEWEY]

Ok, where is the cursor? Is it in the first field of the first display
record?

Can you click on any other field?

--
Build a little, test a little.

Ok so 5 get through the filter. I don't want to see the other 8 records. I
just want to be able to navigate through the 5 there. Reason is I have a
hyperlink field on the form for each record. So If I choose a combo, then 5
records show up, I want to be able lets say to goto the 3rd record's
Hyperlinked field and click on it to open a folder on my hard drive.

I do believe you are missing the idea of a filter. Of the 13 orignal
records only 5 get through the filter. So that is all you get.

A filter is not a sorting and pointing tool.

Is that what you want? A process that groups those 5 records, moves the
focus to one of them and allows viewing the other 8 when you scroll past the
filtered 5?

Sure, no prob!
The 13 records are in the subform.

[quoted text clipped - 17 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

All fields are not enabled except the hyperlink so the cursor is on the
hyperlink field of the first record.
I can't click any other field for this record as they are not enabled, and I
can't click the hyperlink field for any other record, which is what I need to
do. thx

Ok, where is the cursor? Is it in the first field of the first display
record?

Can you click on any other field?

Ok so 5 get through the filter. I don't want to see the other 8 records. I
just want to be able to navigate through the 5 there. Reason is I have a

[quoted text clipped - 16 lines]

 

[KARL DEWEY]

Do the navigation buttons work?

Can you enter a number (3) in the navigation [ 1 of 5 ] and press enter?

--
Build a little, test a little.

All fields are not enabled except the hyperlink so the cursor is on the
hyperlink field of the first record.
I can't click any other field for this record as they are not enabled, and I
can't click the hyperlink field for any other record, which is what I need to
do. thx

Ok, where is the cursor? Is it in the first field of the first display
record?

Can you click on any other field?

Ok so 5 get through the filter. I don't want to see the other 8 records. I
just want to be able to navigate through the 5 there. Reason is I have a

[quoted text clipped - 16 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

no, they do nothing when I click them.
When it says 1 of 5, I goto the 5 and try and delete it and right when I
click in there it just displays 1. I change it to 3 and press Enter and it
says "You can't goto the specified record. You may be at the end of the
recordset. doesn't make sense.

I am guessing it is because the 13 records, including the 5, are not from a
single recordset per say, they are from an assembly of 5 queries, so its not
really a record, but I should be able to navigate I would have thought?

Do the navigation buttons work?

Can you enter a number (3) in the navigation [ 1 of 5 ] and press enter?

All fields are not enabled except the hyperlink so the cursor is on the
hyperlink field of the first record.

[quoted text clipped - 12 lines]

 

[KARL DEWEY]

How did you assemble the 5 queries?
--
Build a little, test a little.

no, they do nothing when I click them.
When it says 1 of 5, I goto the 5 and try and delete it and right when I
click in there it just displays 1. I change it to 3 and press Enter and it
says "You can't goto the specified record. You may be at the end of the
recordset. doesn't make sense.

I am guessing it is because the 13 records, including the 5, are not from a
single recordset per say, they are from an assembly of 5 queries, so its not
really a record, but I should be able to navigate I would have thought?

Do the navigation buttons work?

Can you enter a number (3) in the navigation [ 1 of 5 ] and press enter?

All fields are not enabled except the hyperlink so the cursor is on the
hyperlink field of the first record.

[quoted text clipped - 12 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

Here is the query:
SELECT Sample.SampleID, Binder.BinderNo, AssayDetails.LotNo, BinderDetails.
QCDate, BinderDetails.AssayCode, BinderDetails.LinkedFile, SOP.SOP, SOP.Title

FROM (Binder INNER JOIN ((Sample INNER JOIN AssayDetails ON Sample.SampleID =
AssayDetails.SampleID) INNER JOIN BinderDetails ON AssayDetails.AssayID =
BinderDetails.AssayID) ON Binder.BinderID = BinderDetails.BinderID) INNER
JOIN SOP ON Binder.SOPID = SOP.SOPID ORDER BY Sample.SampleID, Binder.
BinderNo, AssayDetails.LotNo, BinderDetails.QCDate, BinderDetails.AssayCode,
BinderDetails.LinkedFile;

How did you assemble the 5 queries?

no, they do nothing when I click them.
When it says 1 of 5, I goto the 5 and try and delete it and right when I

[quoted text clipped - 15 lines]

 

[KARL DEWEY]

I do not see anything that I know of that would make it not work.

All I can suggest is to start removing the control off the form and fields.

Or maybe someone else can think of something to try.

--
Build a little, test a little.

Here is the query:
SELECT Sample.SampleID, Binder.BinderNo, AssayDetails.LotNo, BinderDetails.
QCDate, BinderDetails.AssayCode, BinderDetails.LinkedFile, SOP.SOP, SOP.Title

FROM (Binder INNER JOIN ((Sample INNER JOIN AssayDetails ON Sample.SampleID =
AssayDetails.SampleID) INNER JOIN BinderDetails ON AssayDetails.AssayID =
BinderDetails.AssayID) ON Binder.BinderID = BinderDetails.BinderID) INNER
JOIN SOP ON Binder.SOPID = SOP.SOPID ORDER BY Sample.SampleID, Binder.
BinderNo, AssayDetails.LotNo, BinderDetails.QCDate, BinderDetails.AssayCode,
BinderDetails.LinkedFile;

How did you assemble the 5 queries?

no, they do nothing when I click them.
When it says 1 of 5, I goto the 5 and try and delete it and right when I

[quoted text clipped - 15 lines]

Any ideas?
Thanks!

 

[gmazza via AccessMonster.com]

Ya I can't get it to work at all. Its weird because when I first open the
form I can navigate to the next record, its when I choose a combo box, and
add a filter to the subform's query based on that combo box, that the subform
can't be navigated to the next record anymore. I cleared the filtered records
yet still can't navigate.

I do not see anything that I know of that would make it not work.

All I can suggest is to start removing the control off the form and fields.

Or maybe someone else can think of something to try.

Here is the query:
SELECT Sample.SampleID, Binder.BinderNo, AssayDetails.LotNo, BinderDetails.

[quoted text clipped - 13 lines]

 

[gmazza via AccessMonster.com]

Does anyone else have any insight they can share on this??

Ya I can't get it to work at all. Its weird because when I first open the
form I can navigate to the next record, its when I choose a combo box, and
add a filter to the subform's query based on that combo box, that the subform
can't be navigated to the next record anymore. I cleared the filtered records
yet still can't navigate.

I do not see anything that I know of that would make it not work.

[quoted text clipped - 7 lines]