invalid reference to the property form/report or mysubform fields return with #NAME?
Here is what I have tried partially unsuccessfully.
The issue I have is that the recordset in f_Activity Details_Datasheet does not update when I edit, delete or add an Activity in Activity Details_Admin.
I do not reply to personal e-mail Hi All, Has anyone figured out how to reset the recordsource of a opennedform?? IIRC, in a Form, you can change the Record Source at the Open event or anytime thereafter, and you do not have to requery, because changing the Record Source causes the Form to be Requeried.
ex: User opens a form, selects a value from combo1, selects a valuefrom combo2, in the After Update event of combo2 write the sql for therecordsource using those two choosen values then do ame.recordsource = str SQLme.requeryor do I 'have' to do a form/subform for thisthanksbobh. Requery even needed since the recordsource is being updated? It would seem from yourquestion that your experience differs... In Reports, OTOH, you can successfully change the Record Source only in the Open event.
Yes, but I can't do it for you with the limited info you have given.
Code the Combo After Update event something like: Dim str SQL as String str SQL = "Select ....blah, blah.." Me. Refresh -- Fred Please respond only to this newsgroup. Requery the form opens with No recordsource, when the after update of cbo Processor code executes I get the following error Run-Time error '2001' You Canceled the Previous Operation if I then choose debug the me.recordsource=strsql is highlighted in yellow bobh.