Is there any way to mix tow logical condition in docmd.openForm criteria?

[uniqe02us]

Hi
How can I use two criteria in docmd.OpenForm? There any way?

 

[bob fitz]

Hi
How can I use two criteria in docmd.OpenForm? There any way?

Yes, with something like:
DoCmd.OpenForm "F1", , , "[TextFieldNameInTable] = 'harry' and [NumberFieldNameInTable] = 3"

 

[uniqe02us]

thanks a lot bob.its so useful for me but i have another problem now!
I try to use an variable value in the where condition .i try this command : ...,"[TextFieldNameInTable] = ' "& var1 &" ' and [NumberFieldNameInTable] = ' "& var2 & " ' "
and its not work. could u help me to fix it ?

 

[VilaRestal]

Numbers don't need quotes round them and don't put spaces between the quotes for strings. It should be

,"[TextFieldNameInTable] = '" & var1 & "' and [NumberFieldNameInTable] = " & var2

and of course you need to replace those field names and variables with real ones or access won't recognise them.

 

[uniqe02us]

thank u bob. i try it and tell u the result.