click event sql problem with sub form

[ggreg]

Problem with
[po]![subfrmpoinv]![amount]
I get an error
How should it be written?

thanks


Private Sub Reviewed_Click()
On Error GoTo Err_Reviewed_Click

Dim SQL_Text As String
Dim msg, response, mystring
msg = "Are you sure the Req is ready Upload ?"
response = MsgBox(msg, vbYesNo)
If response = vbYes Then ' User chose Yes.
SQL_Text = "INSERT INTO rq_requisition ([Description], [Price], [Object],

," _
& "[Department], [Product], [Project], [Comments]) VALUES(Description1 & Description2," _
& "[po]![subfrmpoinv]![amount], Obj, center, Orgn, Actv, ""800"" & Project__ & ""0000"", FH__)"
DoCmd.RunSQL (SQL_Text)
Else ' User chose No.
mystring = "No" ' Perform some action.
End If


Exit_Reviewed_Click:
Exit Sub

Err_Reviewed_Click:
MsgBox Err.Description
Resume Exit_Reviewed_Click

End Sub​

 

[TheAceMan1]

how are ya ggreg . . .

try:

[blue][subfrmpoinv].Form![amount][/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

BTW, why saying you get an error without posting the error message ????

 

[TheAceMan1]

or try this reference:
Refer to Form and Subform properties and controls

See Ya! . . . . . .

Be sure to see FAQ219-2884: