Recent content by jpatrick

Yes, thank you! I'm sorry I forgot to come back here to post. The baldyweb suggestion from jdraw pointed me in the right direction. Thanks again!

Baldyweb pointed me in the right direction. Thanks!

Not needed but if it makes things easier it is fine to allow that option as well.

Hi! Exactly like that but neither County or State would be required, you could choose one or the other or neither. So... #1 - all cities #2 - cities limited to a country #3 - cities limited to a state If I wanted to limit it I could choose a county OR a state. If I did not want to limit I...

Thanks! I'll check those out and report back.

Hi! By Primary I mean the combobox that will display the final results. If you don't want to filter by the options in 2 or 3 you could fill it first. Your options are as follows: #1 - select primary and leave 2 and 3 blank (primary will run it's usualy query to show unlimited results) #2 -...

Hi! I have a combo box working fine but want to filter the list based on a second combobox IF the second cbo has been filled in. I do not want the second cbo to be required. Actually, I have a third cbo also so what I really want is: #1- the primary cbo to not be filtered at all if both the...

Thank you!:eek:

Thank you!:banghead:

I'm so sorry, forgot to change the name of the combobox before I uploaded it but, yes, it is the only one on that form. I've corrected that and uploaded again along with the be. Thanks!

I've uploaded the db, could someone please help me figure out why cboAE on the 'other search' form displays a list of blank values? I know it's gotta be something super simple but I can't figure it out and nothing I find online or on this site helps. I have plenty of other combo boxes set up...

Thanks, Doc! I didn't really understand how to make that work but it pointed me in the right direction and I was able to figure something out. So now I've learned looping through the subform is not sufficient, I need to loop through every record of the subform as well. I'll search for topics on...

Thanks, Cronk! I'm getting 'run time error 438/object doesn't support this property or method' on the two lines indicated below. I have the subform in datasheet view. Any idea why? Thanks again! rt_foundrequired = 0 For Each ctrl2 In Form_Submissions.[Room Types subform].Form.Controls...

Thanks! That got me much closer, both of your code works as desired. I've associated each checkbox or optionbutton to a label by giving them matching numbers for the last 3 digits of their names. It's all working perfectly now except I also need it to loop through the subforms. Could you let...

Hi! I found a very old thread that gave me the basis for this but I can't seem to expand it as I need to. ctrl.Value does not seem to be recognized. My goal is this: -If it's a text box or combo box, required and blank = change background color -If it's a check box or option button, required...