Ordering Form

[ManuNeko]

I have actually 2 questions. They are probably very easy to solve, but I have no idea where to start looking.

1) I have a form (Form1) which has a combo box. When pressing "F2", I start a second form (Form2).

On Form2 I want my records order by Name, but I always have them ordered by ID. I tried the "Order By" property on the form, but that doesn't seem to work.


2) When closing the form, I want the selected (or the newly created record) to be the current record in the Combo box on Form1. How do I do that?

Thanks.

 

[Oldsoftboss]

Problem 1. In the record source of the form create a query that orders by Name

 

[Oldsoftboss]

This should do the trick....

Dave