MS ACCESS

[Ravi]

I have two forms linked to different queries. I want to add the values
of both the forms in one form so want to copy the values in one
form.how to write the expression?

 

[Stefan Hoffmann]

hi Ravi,

I have two forms linked to different queries. I want to add the values
of both the forms in one form so want to copy the values in one
form.how to write the expression?

As long as these two forms are not closed, you can use

Private Sub Form_Load()

myControl1.Value = Forms!NameOfYourOpenForm.Form.Control.Value
myControl2.Value = Forms!NameOfYourOpenForm.Form![FieldnameOfQuery]

End Sub


mfG
--> stefan <--

 

[Steve]

Create a third query that includes both your queries. Add the values you
want to add in the third query. Base your form on the third query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)