Search results

Hi all! Hope someone can help me with a problem that has gotten me stumped. I have a form (Main) that contains a multi-valued field/control. This multi-valued field/control gets its choices from a different table. Also in this form is a button (Print Report) that users click to print a report...

Thanks for the reply and code. That seems to be a better option and helps simplify things. I will try your suggestion and see how it works.

Hi all! Need a little help with a problem concerning multiple IF functions in a form. I have a button that on click will print a report if certain fields in the form have data in them. If not, a msgbox pops up to let the user know that data must be filled and then sets focus on whichever field...

Thanks for the reply. Here is my SQL: SELECT [Event Report].[Members Involved].Value FROM [Event Report] WHERE ((([Event Report].EventDate) Between [Forms]![Date Range Response]![txtStartDate] And [Forms]![Date Range Response]![txtEndDate])); This only shows the items in the list that were...

I know that multivalue fields are not the best to use, but I have a simple database that they work fine in. My question is this: Is there a way to show the entire list of choices in the multivalue field on a report? Not just the ones selected, but all of them, whether checked or not? The...

Sorry been so long to respond. Thanks for the suggestions. I will try to work on it and post what results I come up with.

Hi all, I hope someone can help me with an issue. I have a database with a form called "Main" where users input data and then print a report from it. "Main" has fields in it from another form "Members". This data (from "Members") is shown on "Main' by Dlookup coding, and therefore cannot be...