How to go to new record in unopen table???

[marlun]

Hi. I have a form where I insert records from an excel-file into a table. I have an Autonumber field in that table. And I have a macro that jumps to a new record in a that table, but how do I write?
DoCmd.GoToRecord ( ), , acNewRec

What do I write between the ()???

My tablename is tblInLev

Please help

 

[jebry]

Hi!

Why not just write an append query and run it? Seems like it would be faster.



Jeff Bridgham
bridgham@purdue.edu

 

[marlun]

OK, I think I've tried that, perhaps the wrong way. In my table I have an Autonumber field. It doesn't append anything to the table the way I want. It didn't work with the "Get external data either. I can't understand what's wrong. Do you have any suggestions how to do it the easiest way. I would appreciate a lot.
=)

marlun