Record navigation

[alexasha]

I have a main form and subform with multiple records for one unique identifier.
I would like to create a button to navigate between unique records.
Currently, if I use the standard go to next record button, navigation occures
though subform records. Thus if each unique record has 10 subrecords, I have
to navigate through all of them in order to get to next unique records.
Please help.

 

[Arvin Meyer [MVP]]

I have a main form and subform with multiple records for one unique
identifier.
I would like to create a button to navigate between unique records.
Currently, if I use the standard go to next record button, navigation
occures
though subform records. Thus if each unique record has 10 subrecords, I
have
to navigate through all of them in order to get to next unique records.
Please help.

If you use the main form navigation buttons, you will navigate through the
main form (unique) records. If the navigation buttons aren't there, open the
property sheet in the form's design view, and turn them on.

 

[jing]

Hi,I am sorry that I can't help you,but I need your help,will you reply me
soon?

 

[alexasha]

The buttons are placed on Main form, but still circulate through all records
in subform. I am missing something.

 

[Arvin Meyer [MVP]]

Set the subform control tap stop property to no.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[alexasha]

I knew it was something very simple. great thanks.