I've enclosed a stripped down database that contains a form with a subform. The subform should filter to show the data based on the w_number entered on the form. This works whenever a whole number is used but if a number with a decimal is used, it doesn't. The table format for the w-number is set to double so I'm not sure what is wrong. For example, if I enter 4423, it filters to show the date, however if I enter 4423.9 it doesn't.