Search results

Open the property sheet of the combo box and find "Row Source". You will see the query name there. Instead of the query name, write SELECT * FROM qryMyquery ORDER BY Descriptions; where "qryMyquey" is the name of the query. This should take care of the sorting. Shoji

You can create a text box, say Text1, right next to the combo box. Create a combo box AfterUpdate event and write Private Sub myCombo_AfterUpdate() Text1 = myCombo.Columns(1) End Sub If a combo box has multiple fields (columns), they are referred to as myCombo.Columns(0)...

RichS, Since you just want to pop up a form to show the "Details", it will be easier to use OpenArgs to send the text to the pop up form and display it. In the subform where "Details" is available but hidden, you create a double-click event: Private Sub Details_DblClick() DoCmd.OpenForm...

Thank you, RainLover. I would love to go to Australia too.

Hi All, I recently moved to Scotland, 30 miles south of Edinburgh, from New York where I lived for over 30 years. Originally I came from Japan and went to US to study. Well my life is full of unexpected turns to say the least, but I am enjoying the beautiful Scotland now with my...