Re: RE: [MS_AccessPros] Order By Issue

 

I got it to work...

Changed the row source to: SELECT Archive.ArchiveID, Archive.ArchiveName FROM Archive ORDER BY Archive.ArchiveName;

Column Count: 2

Column width: 0;1

Bound column 1

After Update:

Private Sub cmbCurrentECabinet_AfterUpdate()
  ' Set the cmbCurrentEFolder combo box to be limited by the selected ECabinet
  Me.cmbCurrentEFolder.RowSource = "SELECT MainTitle.MainTitleID, MainTitle.MainLevelTitle FROM MainTitle " & _
     " WHERE ArchiveID = " & Nz(Me.cmbCurrentECabinet) & _
     " ORDER BY MainLevelTitle"
  Me.cmbCurrentEFolder = Null
 
  EnableControls

  'Me.cmbCurrentEFolder = ""

  'EnableControls

End Sub

Thank you.

__._,_.___

---

Posted by: dbalorenzini@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___