Combobox default on form load

[choaspes]

Hi All

Sorry for anyone who's already seen this - total rewrite needed so I've edited. I'd be very grateful for some help.

The records on my main form are navigated by a combo box, and that combo box is set up to display the records alphasbetically. The form itself defaults to the earliest record, whilst the combo box defaults to the first record in its list - which being arranged alphabetically isn't the same record as the form is displaying. How can I make the combo box and the form display the same record by default when the form loads?

 

[cpc]

Have you tried to set the Default Value of the combo box property to blank? (Property Sheet- Data - Default Value)

 

[choaspes]

Setting the default value to blank means that there's nothing in the combo box when the form loads, I would like the combo box to tell me which record the form is currently displaying.