Odd query behaviour

[Bakta]

I am baffled by the following behaviour.

I use a table, with fields like Name, Firstname, Service (like accounting etc..)

I have a form with various fields in amongst which these above.

Here is my source of discontent :

I make a query where the Service is hard written and look for occurences of Name + Firstname as appearing on the current form.

Somethin like
Id_Number, Name, Firstname, Service

with criterias like this :
[Contact].[Name] =[Edit_Form].[Name]
[Contact].[Service] = "Accouting"

! missed purposefully

This one works fine.

But when, in the same request, I add
[Contact].[Firstname] = [Edit_Form].[Firstname]

The query doesn't figure out neither the name or first name as appearing in the Form anymore, and appears a popup box asking for input for both name then firstname.

Is this behaviour "normal"?.

B

 

[maxmangion]

try renaming your field "Name", as it is not recommended to use the word Name as a field name.