Open form and display filtered dataset

[jopi]

Form "Clientes"

[ItsMe]

Not sure how you accomplished it but, you are trying to use data type Text (second example on the left) where Access is expecting data type Number.

[Missinglinq]

To be exact, ID_Animal is an AutoNumber, and to open a Form to the Record whose ID matches, you're using the code

DoCmd.OpenForm "Animais", acNormal, , "ID_Animal like '*" + CxCombAnimal.Value + "*'", , acWindowNormal

The problem is, the Like operator can only be used against Text; it cannot be used with a Numeric field. A Numeric match has to be exact. Replace the above with

DoCmd.OpenForm "Animais", acNormal, , "ID_Animal = " & Me.CxCombAnimal.Value, , acWindowNormal

Linq ;0)>

[jopi]

Great help! Thanks a lot!

[Missinglinq]

Glad we could help!

Linq ;0)>