********* really need help .Please take a look. last to finish************

[Tinny]

Hello everyone ..I really really really really need help with this ..It have to be work but I don know why it’s not working . This is the last thing and I finish my project so if you help me I’ll really appreciate that.
Images and my db Included in my zip

 

[ColinEssex]

You've not attached anything, or outlined the problem. You won't get much help that way!

Col

 

[Tinny]

Currently went you typing I was upload my files Sorry but I have a problem with my upload ..Now it’s ok Here it is

 

[ColinEssex]

If its not too much trouble, can you outline what your problem is.

People on these forums help others voluntarily and many are also doing full time jobs as well and don't have time to wade through stuff trying to figure out whats happening

Col

 

[Tinny]

Yes ok . I am sorry...My problem is That i can speak very well english and if i tell you whats my problem you don't anderstand ..So I try..
I 've got tree form together and a query in a report So..When i press my button to open the report the report is from a query and the query is from my forms textfields
[Forms]![frm_Customers].[LastName]
[Forms]![frm_Customers].[FisrtName] and
[Forms]![frm_Agreements].[CarId]

The problem is that the query can take from the firts form frm_Customers wich is "active" but not from the Subforms ..Thats my problem

 

[jwhite]

The problem is in your reference to the subforms. Syntax for referring to subforms from another object (query/report) is:

Forms!Mainform!Subform1.Form!ControlName

So, to reference control in frm_Agreements:

Forms!frm_Customers!frm_Agreements.Form!CarId

Hope that helps.

 

[Tinny]

Yeeeeeeeeeeeeeeeeap..That Works Thank You!!!!!!!

Really thanks
and if i want a total ? in my form i make a total witch is a sum from my frm_Transactions (3rd form) how can i pass it to my report? do i use a query or i can pass it from my form? in my zip there is my db if you want my infos
But anyway thanks

 

[Tinny]

I forget ..
My first form haven't any Code but my 2nd has

Option Compare Database

Sub Form_Current()

Dim ParentDocName As String

On Error Resume Next
ParentDocName = Me.Parent.Name

If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![frm_Transactions].Requery
End If

Form_Current_Exit:
Exit Sub

Form_Current_Err:
MsgBox Error$
Resume Form_Current_Exit

End Sub


I don't know if it's usefull

thats what i think is can i a put a text field from my form to query and then to report?
Like

SQL:
TOTAL:[Forms]![frm_Customers]![Total]

I try it but dont work

the holle systax is

SELECT tbl_Customers.LastName, tbl_Customers.FisrtName, tbl_Agreements.CarId, tbl_Customers.CustomerId, tbl_Agreements.AgreementId, Forms!frm_Customers!Totals AS newtotalL
FROM tbl_Customers INNER JOIN (tbl_Agreements INNER JOIN tbl_Transactions ON tbl_Agreements.AgreementId = tbl_Transactions.AgreementId) ON tbl_Customers.CustomerId = tbl_Agreements.CustomerId
GROUP BY tbl_Customers.LastName, tbl_Customers.FisrtName, tbl_Agreements.CarId, tbl_Customers.CustomerId, tbl_Agreements.AgreementId, Forms!frm_Customers!Totals
HAVING (((tbl_Customers.LastName)=[Forms]![frm_Customers].[LastName]) AND ((tbl_Customers.FisrtName)=[Forms]![frm_Customers].[FisrtName]) AND ((tbl_Agreements.CarId)=[Forms]![frm_Customers]![frm_Agreements].[Form]![CarId]));