Recent content by HaChIrish

Awesome! Just what I needed. Thanks again.

What date do I put in the form field?

Thanks Pat. Exactly what I needed. Don't really need this part answered, but it'll save me a step: How would I adjust my queries so that I just enter [policynumber] once to pull up the 2 separate reports?

blahblah was actually in another post I made, and that one was answered. What I'm trying to do here is I have an application with about 20 yes/no checkboxes in a form. The report I print is based on the query that feeds both the form and the report. But instead of printing a checkbox on the...

How would I do this in a report? In the form I just use a checkbox, but when I print the report I want it to fill black in a textbox.

Is there a way to change the background color of a textbox based on a yes/no answer? It's basically a checkbox, but I want to use a textbox instead that will fill black if true and stay transparent if false. Is it possible?

I need to be able to click on a control in my form that will pull 2 or more reports based on [policynumber]. The first report would be a cover letter, and the 2nd report would be an application. I can't make the application a subreport because the footer on the letter would screw up the...

Thanks to both of you. Rich's suggestion was a little easier on my puny brain to figure out, but it works like a charm!

MattS, you are the man! Never even thought to look for that option. Thanks a million!

Is there a way to correctly display currency in a bound textbox that includes additional text? the text looks like something like this: ="Your current premium is "& [premium] & ". Please blah blah..." The actual text is longer and more detailed then this example, but even with something...

I have a report and subreport based on respective queries. Both queries have criteria asking for [policy number]. How would I code it so that the subreport will automatically use the same policy number the main report is using? Thanks in advance

That makes sense (didn't even think of that). Now how do I write the expression? I'm still not sure how to specify values in a field.

I'm not sure if I'm in the right part of the forums because this might be a query question. I have a productivity report based on 2 tables: the primary CUSTOMERS and dependent OPTIONS. Options has 1 field (called OPTIONS, the primary key), and the field has the values SOLD, PENDING, QUOTE...

How could you tweak this to use a text box instead of a combo box? I want the user to be able to type in an account number, and if the account number is not entered, then an add account dialog would open.

Thanks!