From Form Header to Form Detail to Table Field

Not sure what you're expecting. When I look in the table after changing the selection in that combo, all entries have the new company ID, which is what that SQL would do.
 
Plus, all of your controls are on your subform and there are none on the main form. No point in linking to a main form if there's nothing on there to link to.

Your subform header looks like it is something you might have wanted on the main form instead of the subform header. Is that true?
 
Is that code for changing all the entries. Thats not what I wanted, sorry. What I was just trying todo is when you open the form and choose a value for the 4 combo boxes that the same values are entered for all the entries in the detail section of the Continuous Form. Not all the existing entries in the table.
 
Yes that is true, I was changing things around to get it to work. But I might not need a sub at all.
 
You'll need to add a WHERE clause to your SQL that restricts to those records, using the appropriate controls on the form. I'm sure Bob will be along anytime now with exactly what you need.
 
I'm sure Bob will be along anytime now with exactly what you need.

Paul, your confidence in me is both humbling and scary :cool:

Unfortunately, I think this is going to take more than I have time for. I'm just about to go start working on finishing a door to my home office.
 
Thanks for for everything so far Paul you have been a great help.

Thanks.
 

Users who are viewing this thread

Back
Top Bottom