problem in a the Where Argument. In a macro

[sistemaPR]

Hi HansV

This is bottom on a form -> to open a form: I put both the conditions together with a.. And

This is not working, can you tell me what is wrong, I want unite, but like that does not work, I have this on a macro -> on a openform, in the where, I want it to open the form base on the member with the same provider. If I try by member: it works by member only but it bring other providers, viceversa ( by Providers its the same ). I also try in the other form example ' Forms![Formname]![field] and did not work either, maybe something was missing. I know it can be done ..

="[MemberID]=" & "'" & [txtMemberID] & "'" And "[ProviderNPI]=" & "'" & [txtProviderNPI] & "'"

[HansV]

The And should be within the quotes:

="[MemberID]='" & [txtMemberID] & "' And [ProviderNPI]='" & [txtProviderNPI] & "'"

PS Please don't direct questions to me personally - there are others who answer questions too!

[sistemaPR]

ok