wherecondition - works in one instance, not the next....UGGH!!!

[KIRK THOMPSON]

I have a form with a few drop dows and a command button. Each command button
has an on-click event, as below:

Button_A: this works
DoCmd.OpenReport "rpt_Cable_info_01", acViewPreview, _
WhereCondition:="RF_Cable_Ident = '" & Me.Combo0 & "'"

....so I copied the above and edited it for Button_B as:

Button_B:
DoCmd.OpenReport "rpt_Test_results_AC_drop_down", acViewPreview, _
WhereCondition:="AC_ID = '" & Me.Combo15 & "'"

Button_B action DOES NOT work.....

Info:
AC_ID: number and primary key
Combo15 = general number

RF_Cable_ident = type not specificed
Combo0 = type not specificed

Thoughts ideas??

Thanks!
Kirk
Phil PA

 

[RoyVidar]

I have a form with a few drop dows and a command button. Each command
button has an on-click event, as below:

Button_A: this works
DoCmd.OpenReport "rpt_Cable_info_01", acViewPreview, _
WhereCondition:="RF_Cable_Ident = '" & Me.Combo0 & "'"

...so I copied the above and edited it for Button_B as:

Button_B:
DoCmd.OpenReport "rpt_Test_results_AC_drop_down", acViewPreview, _
WhereCondition:="AC_ID = '" & Me.Combo15 & "'"

Button_B action DOES NOT work.....

Info:
AC_ID: number and primary key
Combo15 = general number

RF_Cable_ident = type not specificed
Combo0 = type not specificed

Thoughts ideas??

Thanks!
Kirk
Phil PA

When the field is numeric, there is no need for text delimiters (single
quotes)

WhereCondition:="AC_ID = " & Me.Combo15

 

[KIRK THOMPSON]

Roy -

THANK YOU.......THANK YOU.......THANK YOU.......THANK YOU.......!!!!!!

I have 3 books on Access and searched them for the answer, but did not find
it. I will check them specifically for "delimiter."

You save me a lot of money on Tylenol!!

Thanks!

Kirk