By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Automatic data update for a field value for the new record

P: n/a
Hello
Can anybody pls help me out.
I am creating a table with a field that has about 50,000 randomly
generated
values(RandomID). Everytime I enter a new record with new RecordID,
I want the next available RandomID to be automatically assigned to the
new record entry.
The form has 2 textboxes respectively assigned for RecordID and
RandomID.
The moment new recordID is entered, automatically the new randomID
should appear
in the form.
Any help in this regard will be highly appreciated.
Thanks
Anita
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ta*******@yahoo.com (anita) wrote in message news:<6e**************************@posting.google. com>...
Hello
Can anybody pls help me out.
I am creating a table with a field that has about 50,000 randomly
generated
values(RandomID). Everytime I enter a new record with new RecordID,
I want the next available RandomID to be automatically assigned to the
new record entry.
The form has 2 textboxes respectively assigned for RecordID and
RandomID.
The moment new recordID is entered, automatically the new randomID
should appear
in the form.
Any help in this regard will be highly appreciated.
Thanks
Anita


Is this a trick question or is there some reason you can't use an
AutoNumber and set the New Values property to Random?
Nov 13 '05 #2

P: n/a
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf*************************@posting.google.c om>...
ta*******@yahoo.com (anita) wrote in message news:<6e**************************@posting.google. com>...
Hello
Can anybody pls help me out.
I am creating a table with a field that has about 50,000 randomly
generated
values(RandomID). Everytime I enter a new record with new RecordID,
I want the next available RandomID to be automatically assigned to the
new record entry.
The form has 2 textboxes respectively assigned for RecordID and
RandomID.
The moment new recordID is entered, automatically the new randomID
should appear
in the form.
Any help in this regard will be highly appreciated.
Thanks
Anita


Is this a trick question or is there some reason you can't use an
AutoNumber and set the New Values property to Random?

Thanks Pieter for your reply. Unfortunately I have been asked to use
the existing alphanumeric generated random numbers. So I cant set it
to Autonumber.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.