VBA Passing text box value from one form to another text box in another form
I am having difficulty (probably me being thick) passing the value of a text box in one form to another text box in the next form. Basically the idea is that the user can see the user id and name for each form and doesnt forget what record he is inputting for.
The code for the first text box input seems to work OK.
Public Sub SIPPNo_AfterUpdate()
SIPPNumber= SIPP.No.Text ' variable SIPPNumber as input by the user in text box SIPPNo
I have tried the following
MemberDataInputForm.SIPPNOData.Text = Me.SIPPNo.Text
Also I have tried
SIPPNoData.Text = Forms!USPcalculation!SIPPNumber
Whatevever I try I cannot get VBA to do what I want which is to put a copy of SIPPNo Text box (prefilled with the user input from teh previous form) from form USPcalculation into the next form MemberDataInput Form.
Variables are declared separately and publicly in the module.
Any suggestions please?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.