I get a Type Mismatch error 13. I have set the value of the text box
on form B to be equal to another text box on open form A, when form B
opens. I have checked the table and the text box to be sure the formats
are the same.
It all works if I just enter the info on form B manually. Is there a
statement that just copies the value of the info instead of saying text
box A = text box B?
Any ideas on how to work around this will be appreciated.(code below)
Private Sub Save_Click()
Dim qdf As DAO.QueryDef
Set qdf = CurrentDb.QueryDefs("Q_acc_Insert")
Dim str As String
str = " INSERT INTO AccCharges (TN) values (" + "'" + Me!TN + "' )"
qdf.Execute
Exit Sub
End Sub
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
