Next record after based on a sorted field not index

[Chris Salcedo]

I have a form with subforms (contact database with company--contact--
call data).
I have a combo box that finds the company info (this is sorted
alphabetically). What I want to do is after the name selection (I get
all the correct info at htis point) got to the next record or previous
record.

I use the add button wizard etc. and this gives me next/previous
buttons but what it does is next record based on the key (autonumber)
not the next name (sorted of course)

How can I do this?

 

[Marshall Barton]

I have a form with subforms (contact database with company--contact--
call data).
I have a combo box that finds the company info (this is sorted
alphabetically). What I want to do is after the name selection (I get
all the correct info at htis point) got to the next record or previous
record.

I use the add button wizard etc. and this gives me next/previous
buttons but what it does is next record based on the key (autonumber)
not the next name (sorted of course)

Sounds like the form's record source should be a query that
sorts the records by name.

 

[Chris Salcedo]

Sounds like the form's record source should be a query that
sorts the records by name.

And you would be correct!!! that fixed it , I had been using the table
instead of a query ....
Thanks