Recent content by MattoCrim

Hi thanks for your reply. I decided to creat a filter rather than a DCount. The filter is generated by a button filtering my Table. Not ideal but works and can be progressed to what I want. Applyfilter:Forms![Projector Selector]!txtRatio Between Projectors!Ratiofrom And Projectors![Ratio To]...

Hi all. I have a table called projectors, on projectors I have make/model/ratio from and ratio to columns. I have created a form to which I will put two text boxes txtScreen distance and txtScreen size. I have a third text box txtratio. I have my calculation set to auto fill txtratio and this...