Next record after based on a sorted field not index

  • Thread starter Thread starter Chris Salcedo
  • Start date Start date
C

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?
 
Chris said:
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)
Click to expand...


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

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