Search results

Hi arnelgp - I managed to use your example to achive exactly what I wanted. I am very rusty and, despite trying, could not have easily figured this out on my own - thank you so much. :)

Ah, I can see what yo are doing with this and, although different to the way I have things set up, I think this might work - thank you, I will let you know :)

Hi DB Guy So, My combolist has numbers ranging from 1 - 20. Each number represents (for example) a car so 1 = Jeep, 2 = Ford, 3 = Ferrari, 15 = Porsche If I select 1 from my combolist I want to see all of my Jeeps. If I select 2 I see all of my Fords. However, if I do not make a selection I...

Hi CJ - thanks for your speedy response. The 'unbound' control on the form passes the value to a text field hence I was using "". I am more than happy to target the control directly as long as all records are displayed if nothing is selected on the control. I have used Like "*" &...

Hi Folks It has been about 20 years since I have used Access so very rusty I am trying to add a criteria field to a query as either, a single number selected on a form or, everything greater than 0. Typing >=0 directly into the criteria field returns all the records (desired result). However...

Hi Folks - I started learning Access in the 90s but haven't touched it for about 20 years. Trying to get my head around it again now. Oh, and I play guitar :)