Exclude enter query records from linear record navigation

[GSS]

Hi,

I have created a form linked to MSSQL. The query part of the form has "<< <records but when you query the records with a search value to create a subset
then the navigation does not work. I'll try to explain, I used this to create
the navigation:

http://www.bizsupportonline.net/infopath2003/sequential-db-table-record-navigation.htm

But this does not work unless you are returning every record in sequence.
Could anyone suggest a way to cycle/navigate through only returned results
not all results up until the last query match?

i.e. records 1,5,8, and 20 match query so I want to navigate 4 records not
all 20!?

Thanks and Regards,

GSS

 

[S.Y.M. Wong-A-Ton]

It works fine for me, that is, when I use one of the queryFields to perform a
query, the data set returns only those records that satisfy the query and I
can navigate sequentially through only those records that satisfied the
query; not all records in the table. I'm not sure what kind of solution
you're envisioning.

 

[GSS]

Hi ,

Thanks for the response,

Please can I clarify that if the query returns records 1,3,5,10 as matches,
when you use the ">" button you see records 1,3,5, and 10 in sequence and not
see records 2, 4,6,7,8,9?

Regards,

GSS

 

[GSS]

Hi,k

I double checked the expression, updated it and it worked!

Thanks for all your help.

 

[S.Y.M. Wong-A-Ton]

No worries; glad you got it to work.