SQL Update with Subforms

[Guest]

I have a main form "FrmA" and a subform "DESC". I'm trying to update a table
Anesth with fields from both th form and subform. I swear this was working,
but now I'm no longer getting the subform data. I'm certain there's
something wrong with this format: Forms!FrmA.DESC![line] Any ideas?


Heres a sample:

Dim strSQL As String
strSQL = "UPDATE Anesth SET [ip_date] = Trim$([date]), " & _
"[ip_lastname] = Trim$([lastname]), " & _
"[ip_firstname] = Trim$([firstname]), " & _
"[ip_desc] = Forms!FrmA.DESC![line] " & _
"WHERE Anesth.[fldacct] = [pat-acct];"
DoCmd.RunSQL strSQL

 

[Guest]

Forms!FrmA.DESC.Form![line]
or
Me.DESC.Form.[Line]

These assume that the name of your subform control is DESC.
Barry

 

[Guest]

That worked....many thanks!!!!

Forms!FrmA.DESC.Form![line]
or
Me.DESC.Form.[Line]

These assume that the name of your subform control is DESC.
Barry

I have a main form "FrmA" and a subform "DESC". I'm trying to update a table
Anesth with fields from both th form and subform. I swear this was working,
but now I'm no longer getting the subform data. I'm certain there's
something wrong with this format: Forms!FrmA.DESC![line] Any ideas?


Heres a sample:

Dim strSQL As String
strSQL = "UPDATE Anesth SET [ip_date] = Trim$([date]), " & _
"[ip_lastname] = Trim$([lastname]), " & _
"[ip_firstname] = Trim$([firstname]), " & _
"[ip_desc] = Forms!FrmA.DESC![line] " & _
"WHERE Anesth.[fldacct] = [pat-acct];"
DoCmd.RunSQL strSQL