ACCESS 2007
A-B-C-D
A-D-F-R
S-B-R-F
S-E-D-R
S-L-R-F
WITH EACH LETTER A DIFFERENT FIELD
WHEN I ASK THE LIST BOX TO LOOK FOR RECORD S-L-R-F, THE SEARCH STOPS AT S-B-R-F, AND THIS RECORD IS SHOWN IN FORM, NOT THE REQUESTED S-L-R-F.
SO IT STOPS AT THE FIRST LETTER FROM THE SEARCH
A-B-C-D
A-D-F-R
S-B-R-F
S-E-D-R
S-L-R-F
WITH EACH LETTER A DIFFERENT FIELD
WHEN I ASK THE LIST BOX TO LOOK FOR RECORD S-L-R-F, THE SEARCH STOPS AT S-B-R-F, AND THIS RECORD IS SHOWN IN FORM, NOT THE REQUESTED S-L-R-F.
SO IT STOPS AT THE FIRST LETTER FROM THE SEARCH