Autofil from Numbers between two fields

[MattoCrim]

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 works perfectly.

My issue: I need a list box/combo box to return the projectors which have the same ratio as txtratio but to make it even more complex. Just in case the calculation isn't an exact match i need it to compare between "ratio from" and "ratio to" and return the answers.

Hope this is straight forward

Thanks,
Matt.

 

[John Big Booty]

You could use the DCount() function to check if there is an exact match with your calculated ratio, If there is you use a simple select query to populate your list box, otherwise you use a between query to return values either side of your calculated ratio.

 

[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]

Thanks,
Again.

Matt.