Filtering records in a form between two unique values

M

McLink2006

I am self-taught in Access so I am no doubt missing the obvious here. I am
trying to filter records within a main form that has two subforms so that I
can search between two item numbers that are in text boxes due to having
zeroes in front of the number and the number contains a hypen ##-####. I can
input the beginning value into a filter and get all records including and
after the first entry but if I try to search between two values I get nothing.
If this doesn't make sense just let me know and I can elaborate. As I am new
to Access I have no idea how to use visual basic so if possible, try to help
without using VB. Thanks for any advice!
 
Top