D
Dan
I want to open a form that only has the records where the
[status] = expired and the [last name] starts with the
selected letter. This is what I have so far but the last
part, [Last Name] Like '" & firstLetter & "'" doesn't work
firstLetter = InputBox("Which letter do you want to
print")
DoCmd.OpenForm "Envelope", , , "[Status] = '" & "Expired"
& "'" & " AND [Last Name] Like '" & firstLetter & "'"
[status] = expired and the [last name] starts with the
selected letter. This is what I have so far but the last
part, [Last Name] Like '" & firstLetter & "'" doesn't work
firstLetter = InputBox("Which letter do you want to
print")
DoCmd.OpenForm "Envelope", , , "[Status] = '" & "Expired"
& "'" & " AND [Last Name] Like '" & firstLetter & "'"