W
Wayne-I-M
OK - try this (different tack)
Would it be possible to loop something like this through each record on a
filtered (continous) form and append a new record in the table
Dim wayne1test As ADODB.Connection
Set wayne1test = CurrentProject.Connection
wayne1test.Execute "INSERT INTO tblflights (bookingref,flightdate) VALUEs ("
& Me.txttempBookingRef.Value & "," & Me.txtFlightDate.Value & ")"
Basically trying to (still) append a new record to the table for each record
in the form
Any help would be great
Thanks
Would it be possible to loop something like this through each record on a
filtered (continous) form and append a new record in the table
Dim wayne1test As ADODB.Connection
Set wayne1test = CurrentProject.Connection
wayne1test.Execute "INSERT INTO tblflights (bookingref,flightdate) VALUEs ("
& Me.txttempBookingRef.Value & "," & Me.txtFlightDate.Value & ")"
Basically trying to (still) append a new record to the table for each record
in the form
Any help would be great
Thanks