Updating Form

[dah]

Hi,

I developed a form, based on a table, which is working fine until now. Recently some names were entered into the form. Since their ID number is an autonumber, these new entries went at the bottom. This didn't seem like a problem but for some reason the names will not sort alphabetically. I can sort in the table, either on the ID number in which the names are out of order or on the last name in which the numbers are out of order.

I have referential integrity set up as well as cascade update enabled but the form itself does not update. This is a problem since in the form, the ID number is a combo box and one can look up the name/number from a drop down list. The newest names do not appear until way at the end and it now looks like I have two groups of name (A-Z and then at the bottom it starts over A-Z). How might I fix this. Is there a way to sort the records in the form? Since the form is running off the table I don't understand why this does not work.

DAH

 

[ghudson]

Check the help files for the form's OrderBy Property. That will allow you to sort the form's record source the way you want.

HTH

 

[Pat Hartman]

You need to base the combo's rowsource on a query. The query needs an order by clause.