error inserting into table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sub test()
For Words = 1 To 5
INSERT INTO test SELECT * FROM NewCustomers;

Next Words
End Sub
 
Hi,


CurrentDb.Execute "INSERT INTO .. . ", dbFailOnError



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top