To be exact, ID_Animal is an AutoNumber, and to open a Form to the Record whose ID matches, you're using the code
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
Code:
DoCmd.OpenForm "Animais", acNormal, , "ID_Animal = " & Me.CxCombAnimal.Value, , acWindowNormal
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007