Recent content by Farmer

Thanks, I think my main problem is that I have a form derived from a query as the subform but it won't allow me to make it a child. When I set up the master child link it thinks that the ID of the master is a filter and I lose my records. (Sorry so long before replying but ended up having...

Thanks Bob, I will try it tomorrow (don't have my work computer with me at the moment). It kept getting stuck on the SET but maybe I was typing something silly. Regards Farmer

Thanks but I just can't get it to work. I have a form with a subform called frmPCVouchers. The subform is derived from a query to select all Vouchers not reconciled. There is a button on the main form and when it is clicked on I want the field PCisReconciled to be updated to True. The table...

That sounds easy enough but how do I refer to the subform? Sorry but I am new to this. Your efforts are appreciated.

Hello Everyone:banghead:

I'm pretty new to this but I could not get this to work. It kept saying there was an error on the DLookup