Where Condition In Access VBA

[gamezcua22]

I neen help on the following syntax. I keep getting a type mismatch error. Any help would be apreciated.

DoCmd.OpenForm "frmLTSByMachDisplaySpef", , , "[MachineName]= '" & Me.txtMachineName & "'" And "[txtBlankStatus]='" & Me.txtFilterCheck & "'"

 

[tweedle]

i think your And may be misquoted:

DoCmd.OpenForm "frmLTSByMachDisplaySpef", , , "[MachineName]= '" & Me.txtMachineName & "' And [txtBlankStatus]='" & Me.txtFilterCheck & "'"

 

[gamezcua22]

It works thanks you, but it doesnt make sense to me can you explain the syntax?

 

[tweedle]

The And as you have it is positioned to be the logical operator for the criteria string being concattenated
& Me.txtMachineName & "'" And "[txtBlankStatus]='" &

The And as written here
& Me.txtMachineName & "' And [txtBlankStatus]='" &
is used as a logical operator within the sql/query statement; so it's passed through as part of the sql statement.

 

[gamezcua22]

Got IT!!! spend my whole friday tryin to figure this out!!! Thanks a lot.

 

[gamezcua22]

so if i have more than 2 and statements how would the syntax be written?

 

[tweedle]

Same ways

keep your ampersands(&) to connect strings
keep your logical And inside the strings so they are part of the sql.

NOTE: watch the whitespace inside the sql statement:
This would render a syntax error: "'And [txtBlankStatus]='"

 

[gamezcua22]

There we go!! Got it, thanks for all your help!!

 

[tweedle]

Successes are nice!
Thanks for coming back to say so.

 

[gamezcua22]

They are indeed!! Thank again.