find a record

[crich21]

I am getting all the bugs out of my program thanks to everyone here.

Need some more help. I have a form based on table1. when the form opens it automatically goes the the first record ever entered in the form. is there a way to make it go to the first alphabetical record?

Thank you in advance
Chad

 

[shay]

Hi

Make a query based on Table1 in which you sort the records into the required order, then use the query as the recordsource for your form.

hth

shay

 

[crich21]

Thank you shay.
That worked beautifully.

I am trying to make a inventory program to make my job easier at work and I appreciate your help tremendously.

Thanks again
Chad