next and previous navigation buttons

[btappan]

I have inserteted the next and previous record navigation buttons into my record entry form, my problem is that they go to the records based on the order they were entered and not based on the alphabetical part number list i have set for the unique identifier. Because new part numbers are entered one by one, and not usually in alphabetical order, the navigation is'nt working for me. How can i change the way the navigation works? keep in mind i am very new to access so simple terms please

 

[boblarson]

 

[btappan]

i am on access 2007 and my properties on the right are different and there is no record source line that i can see.

 

[Oldsoftboss]

Have you selected the form, not a control?
Do you have the All tab selected?

 

[Oldsoftboss]

PS:
Very impressive response boblarson, but in the query, you didn't specify a sort order.

 

[btappan]

Have you selected the form, not a control?
Do you have the All tab selected?

yes to both.

I noticed one line says: on click: [Embedded Macro]

do I need to change the macro and if so, how?

 

[boblarson]

PS:
Very impressive response boblarson, but in the query, you didn't specify a sort order.

Fixed in the above post

 

[boblarson]

Okay, Here's the Access 2007 Version

The Access 2007 Version:

 

[Oldsoftboss]

boblarson, you have waaaay too much time on your hands

 

[Oldsoftboss]

Fixed in the above post

Post Delete.......

 

[btappan]

thank so much!!!

 

[boblarson]

boblarson, you have waaaay too much time on your hands

With SnagIt, it takes very little time to pull it together. I love that program. I used to think, "I don't need it. I can use Microsoft Photo Editor." Then I actually tried it and am hooked.

 

[RexesOperator]

In the for what it's worth department, I love this way of visually explaining things. Without meaning to sound trite or cliche a picture is really worth a thousand words. My reaction? WOW!

 

[Cosmos75]

boblarson,

Really cool way of providing an answer!

BTW, there is a free screen capture utility that I use - MWSnap. Doesn't have all the features of SnagIt, but it's free!