Search results

I believe it is because you are actually sending the WHERE portion of a SQL statement and you have to refer to the actually fieldname. Good luck!

Yes. Try the code now with: DoCmd.OpenReport stDocName, acViewNormal, , "CoNumber=" & Me.CoID

Let's see if I got this: You have a report named rptPrintFormMain. It's Record Source is qryPrintFormMain. That query contains a field CoNumber. If this is correct, then here's a question. In your report, you have a text box named CoID. What is that text box's Control Source? If the first...

Your code looks perfectly OK to me. So I started backtracking and re-reading the previous posts more closely because I remembered you had it working with a more complicated method. I saw one inconsistency that might be a problem or might just be the way you phrased it. Your post of...

It is hard to respond because there are several ways you might have set up your initial combo box to work. I assumed you used the Combo Box Wizard as a starting place. I've attached a file with my solution. Basically, I would set up a combo box (and related code) that is almost identical to...

I think the solution can be even more simple. On the click command of your "Print this record" button: DoCmd.OpenReport "rptPrintFormMain", acViewNormal, , "[CoID]=" & Me.CoID This assumes that CoID is a number and that you are printing the report and not just previewing it.

Thanks! I was able to use that to accomplish my goal. Since my combo box was in a datasheet and the column width could be changed by the user, I tested until I determined that the width of the "arrow" is about 240 twips. So I can test the X value and if it is between (columnwidth-240) and...

Does anyone have an idea on how to capture the event of clicking on the down-arrow of a combo box. I don't want my code to trigger on the Enter, Exit, or Change events but ONLY if the user clicks the down arrow. Thanks.