Search results

Darn - I spoke too soon. Everything was working properly so I saved and re-opened my form and I am back to square one. The Control Source of the unbound field within the f_ActivityDetails subform is now =[Forms]![f_MainTripForm]![f_ActivityDetails_SFC].[Form]![Company_DD]...

Thanks again, VB - I had just dragged my subforms onto the parent forms without creating a SubForm control, which means that the Name and the SourceObject had the same name. Now that the SubForm controls are set up properly, everything works perfectly!

Thank you - I will need to figure out the form load sequence issue. I still think there is an issue with the WHERE statement because when I remove the drop down, I dont get the the Enter Parameter Value error, but the unbound field that has Control Source...

Hello - I am going crazy trying to sort out what should be a very straightforward reference to a field on a sub-form. There is an error in the WHERE clause of my query but I can't figure it out. The hierarchy of my data is as follows: Trips -> Activities -> Contacts I have a main form...