Recent content by JMZ

Thank you for responding.

How can I get a ComboBox selection to match one of three fields and fill in a subform? I tried the OR operator but could not get it to work.

I asked for VBA because I tried the OR in a Query SQL, but I could not get it to reference the combobox to, as I am not that proficient in SQL.

I have a huge problem going on for 2 weeks, I am trying to get my ComboBox selection to look at 3 different fields for a match and fill in the TextBox controls with those records in a SubForm. Can someone explain the VBA needed to get a ComboBox to look at multiple fields for a match? Example...

Thanks gentleman. I'll leave it at that, I've wasted enough of your time. GPGeorge Thank you for the, Food for thought Link, I'll read it right after I solve this simple problem I created.

Sorry, can not post anything. But this is what I need, in my report footer I have a text box to count a character in the Detail Section, Exp: A, A, A, B, C, D, D and using Count() it gives a value of "7" but what I really need is a value of "4". Only count the three A's as 1 not 3, the D's as 1...

In a report Form Footer I placed a text box and =Count([Item]) in the control source, works like it should. Now I'm trying to change it so I get a count of only the unique value, not counting the same item twice. Any ideas? jim

Try this... DoCmd.OpenReport "ReportName", acViewPreview

I have something like that on another form but instead of a table, I just use MsysObjects in a SQL Select on the Combo Box RowSource and it list all Reports. Just select a report in the Combo Box and tap the command button to print. I had not used an Option Group before and while I was creating...

Cronk, your line of code was close, I made a change and it works great. It looks at the Report Name beside the button and prints that Report and the same for the other buttons with different Report Names. Now I'm off to finish it, by setting up an Admin Form where I can add or replace...

Thanks for the help, everyone. Sorry for the CrossPost, didn't realize I did that.

I have an Option Group with 7 Radial Buttons and the label is the name of a different report for each button. I am using Case Statements for each button and what I would like to do is have each Case Statement look for the label name and place it in the DoCmd that opens the report for preview...