I have a Form "Form1" with an command button having following on click code :
DoCmd.OpenForm "Form2", acNormal, , , acFormEdit, acWindowNormal, CARD.Value
On Form2, I have following code on "OnOpen" function and I get the value of "card" on "text48":
DoCmd.GoToRecord , , acNewRec
Text48.SetFocus
Text48.Text = Me.OpenArgs
Now I want to transport the value of one more field "qty" from Form1 to Form2. I could not find any help from MS Access Help and hence temporarily I have set up a combo box in Form2 which has in its Row source "qty" from Form1 but the user has to open the combo box every time.
I there any other way to get value of 2 fields across to Form2 automatically?
Thanks in advance for all ideas.
DoCmd.OpenForm "Form2", acNormal, , , acFormEdit, acWindowNormal, CARD.Value
On Form2, I have following code on "OnOpen" function and I get the value of "card" on "text48":
DoCmd.GoToRecord , , acNewRec
Text48.SetFocus
Text48.Text = Me.OpenArgs
Now I want to transport the value of one more field "qty" from Form1 to Form2. I could not find any help from MS Access Help and hence temporarily I have set up a combo box in Form2 which has in its Row source "qty" from Form1 but the user has to open the combo box every time.
I there any other way to get value of 2 fields across to Form2 automatically?
Thanks in advance for all ideas.