Recent content by paddleman44

Good day everyone. Here is my problem. I need to create a report that will display photos. The problem is that the number of photos to display for each site varies...some sites have 4, some may have 9. In the report, I want to have only 4 image boxes if there are 4 photos, i.e the same...

I got it working on both standalone subfrom and when it is part of the mainform. Perhaps this is what you were getting at with your last sentence, ajetrumpet. All I did was reference [cbo1] with out any of the reference to forms..... Thanks again to forum. DJ

Thanks again. I created my subform as a form from the database window. I added the subform to the mainform using the toolbox. DJ

ajetrumpet Thanks for the reply. I have the mvps.org syntax line tacked to my wall, and have for some time as it is an excellent reference. I appreciate (or think I do) the difference between containers and objects ---the container is the name given the subform when adding it to a mainform...

Thanks for the reply. You are quite right, the Requery is on the AfterUpdate event. I tried your recommended syntax and the query does not work. When I substitute a period for the second bang i.e. [Forms]![YourSubFormContainerNameHere].[Form]![ComboBoxName] The subforms works perfectly when...

Good Day. I will apologize in advance for yet another thread on this issue but, despite many searches and attempts, I have yet to solve my problem. So.... I have two (bound) combo boxes on a subform. I want to limit the picks of the second based on the first. I have opted for the OnChange...

Hello All. I have a number of sub-subforms on a tab that I want to be visible (or not) based on values of a cbo on the main form. I have figured this one out. However, when I call for the sub-subform to be Visible=False, I get a bug report stating that you cannot make visible=False when a...