inherited a mdb (1 Viewer)

Dick7Access

Dick S
Local time
Today, 16:44
Joined
Jun 9, 2009
Messages
4,201
inherited a mdb of about 150 names and addresses and saved it in accdb.
I am trying to spruce it up. On the main form I put a cmd button.

Code:
DoCmd.ApplyFilter "qryFindLastName"


I want it to find all the names with the same letter, and then go to datasheet view.

No matter what I try fails. Any ideas?
 

Ranman256

Well-known member
Local time
Today, 16:44
Joined
Apr 9, 2015
Messages
4,339
I have a form, with a listbox of all names.
a list of Letters, click the letter list ,the names filter down to that 1 letter.

on AFTERUPDATE event of the alpha list
lstNames.rowsource = "qryFindLastName"

qryFindLastName = select named from tNames where [last] like forms!myForm!lstAlfa & "*"

alpha list.jpg
 

Users who are viewing this thread

Top Bottom