Still trying to learn
- Local time
- Today, 08:26
- Jan 10, 2011
I tried to modify the code found on BaldyWeb that opens a record set and includes all the records. So far I have gotten to this but nothing happens. I definitely have records where the Organization name begins with B. If I could get this to work then I could use a letter picker to change the B to any letter.
DoCmd.OpenForm "frmNewNames" Dim rs As Object Dim sBookmark As String sBookmark = "B*" 'I can substitute a letter picker for the letter later DoCmd.OpenForm "frmNewNames" Set rs = Forms!frmNewNames.RecordsetClone rs.FindFirst "Organization = '" & sBookmark & "'" Forms!frmNewNames.Bookmark = rs.Bookmark Set rs = Nothing