Setvalue action - 2 seperate macros using same column?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hello.
I hope someone can help. I have 2 macros which open 2 different forms but
they reference the same column. The first macro opens the form and auto adds
my ClientID number to the new form (spouse details) using the SetValue
action, which is what I want and it works fine.
The second form (alternate address), opens but I get an error saying "You
tried to run a VB procedure that improperly references and property or method
of an object".
The macro's item value has been changed to reference the correct form name
(alternate address) and the expression is the same as for the spouse details
form. Is it failing because you cant use the same column (ClientID) in two
seperate macros??

Any help will be much appreciated.
.



Relevant Pages

  • Re: ObjLibrary references question
    ... this template with a VB project using these macros as desired, ... > || opens the doc with his template, the reference will be missing and the ... > He opens it. ...
    (microsoft.public.word.vba.general)
  • Re: ObjLibrary references question
    ... or is it set in my template, ... It contains macros and a reference to library qwerty.olb. ... He opens it. ...
    (microsoft.public.word.vba.general)
  • Re: Problems in saving excel file using excel macros
    ... first time when I re-assign the macros it works. ... >> to execute any of the macros in the original worksheet, it first opens the ... >> coding of the macros to see if Excel made reference to the new file that ...
    (microsoft.public.excel.programming)
  • RE: open arguments.
    ... Can you add a value to the Reference column? ... Dim rst As Recordset ... This opens the form specified by stDocName in data entry mode and passes the ...
    (microsoft.public.access.modulesdaovba)
  • RE: open arguments.
    ... The original to add a complete new quote, one to edit a quote and one to ... Dim rst As Recordset ... This opens the form specified by stDocName in data entry mode and passes the ... You want to store your reference so poke it into the reference field. ...
    (microsoft.public.access.modulesdaovba)