Recent content by benjew

Hey All, I fixed it. Here is the code I used: Private Sub Form_AfterInsert() Dim db As Database Dim rst0 As Recordset Dim rst1 As Recordset Dim rst2 As Recordset Dim rst3 As Recordset Dim strSQL0 As String Dim strSQL1 As String Dim strSQL2 As String Dim strSQL3 As String Set db =...

Hey all, I fixed that issue. Working on another one now. I'll let you know if I get stuck. Ben Wion

Well here is what I am trying now (new code in red): Private Sub Form_AfterInsert() Dim db As Database Dim rst0 As Recordset Dim rst1 As Recordset Dim rst2 As Recordset Dim rst3 As Recordset Dim strSQL0 As String Dim strSQL1 As String Dim strSQL2 As String Dim strSQL3 As String Set db =...

I currently have a form called "Aircraft" that allows the user to make new aircraft entries. The form consists of an Autonumber textbox(non-updatable), a SN textbox, an AircraftType text box and a WorkAuthDate text box. All these textboxes are linked to a table, tblacftsn. Here is what I am...