Automatic Adding Record from prompt

  • Thread starter Thread starter KimTong via AccessMonster.com
  • Start date Start date
K

KimTong via AccessMonster.com

Hi,

I have a project to add a several records automatically from user's prompt.
The user has to input the range of field 'Ahhoc#' to add on 'Table1'
automatically. The prompt looks like this:
From: 10101
End : 10200

So the program will add 100 records on table1 and save 10101-10200 to field
'Adhoc#' in order. I have a logic like this:

For I=From to End
AddRecord
Adhoc#=I
Save it in table1
next

But I don't know to write exactly in VB. If anyone can help me, I'm really
appreciated.

KF
 
It is a bit unusual to need to add "blank" records in a table. If you'll
explain what having these "100 records" will allow you to do, the folks here
in the newsgroup may be able to offer alternate approaches...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top