Solved Simple Filter Not Finding Records

[p_bij]

When I filter a field by right clicking and entering a value (107611.003) it cannot find the record. The record does exist, however! I have the same problem with 107611.002. However it does find 107611.001! And if I use the between filter, (between 107611 and 107612) it finds all three records. I have no idea what's going on. But I believe whatever is causing this is also preventing the VBA code (DoCmd.OpenForm "Form_AllFiles", , , "Legal_File_Number = " & Me.EnterLegalFileNumber) from working.

 

[theDBguy]

What is the data type of the field?

 

[p_bij]

The reason

What is the data type of the field?

Double, which I just realized, is probably the problem. I changed it to Decimal and it works! Thank you!

 

[theDBguy]

The reason

Double, which I just realized, is probably the problem. I changed it to Decimal and it works! Thank you!

Glad to hear you got it sorted out. Good luck with your project.