Forms not working Correctly?!!!! Plz Help

[moleary]

One of my data entry forms is not working correctly when I use the combo box the names are alphabatized and in order but when I try to use the record page forward on the botton of the form the records are out of order? In the table they are in order as well???

 

[Howlsta]

Check that the forms underlying query has the name field set to ascending.

Why do you want to use the navigation buttons if you can select the name from the combo box, anyway?

Rich

 

[moleary]

It is not based on a query it is based on the table, but sometimes to go to a certain record you have to use the navigation buttons because the records do not a have a complete ID number and if you choose from the drop down menu it will not go to that specific record so you have to scroll to that record.

 

[Howlsta]

I always base all my forms on a query even if it is exactly the same design as a table. This way if you have to change something unexpectedly later on, such as inserting criteria, you can do so straight away.
Just a thought.
Rich

 

[moleary]

Thanks! I will try that and see if it helps!