copy data from a subform to the main form

[declanfogarty]

I recently update my access to 2010 because MS were giving the licence out cheap but it has wrecked my old macros in my old version patient database
I have a main patient table and main form


I used to use button to open a search query do display proceedure codes
I used to select the correct proceedure and my macro
would paste the proceedure and codes into that patient record

I get "microsoft access cannot find the object 'updatevaluescode' "
I have a button on the procedure page which will select one or more values and using the old setvalue action
transfer that data back to the main patient page

I have tried to explain in on the attached picture
I used a simple parameter query to filter the proceedure
ie T2000 as a parameter would find all the codes a a long table matching and display them

Im looking for help thanks
Declan

[Rod]

Declan,

You've gone to a lot of trouble describing your problem to no avail.

Take a step back for a moment. Access cannot find an object (unfortunately Access is not telling us what type of object) called, 'updatevaluescode.' That name is not one I recognise as an Access object and does not conform to Microsoft's naming standards, so in all probability the object is user-defined. The name, having the element 'code,' suggests a VBA module or perhaps a misnamed macro. Start looking for that.