Set form to automatically enter next ID number upon opening???

R

reservedbcreater

i have a survey form....its actually 17 forms, that follow each other,
corresponding to 17 tables, each a different section of the survey.

i want each entire survey to have an ID#.

so there is an ID# field on each form.

I coded it so that it takes the value in the ID# field from the first form
and places it in the ID# field of all otehr forms.

my problem is, ive done 15 surveys so far... so 15 ID#'s have been used
(1-15)......how do i get it so when i open the first form of a new survey
it fills in ID# field with the next unused ID#(16) autmatically
 
G

Guest

reservedbcreater said:
no it wasnt
Click to expand...

Create an 18th table called surveyids, have one column - autovalue, int
unique number - you could addsurvey date etc. Have a master form, based on
this; make each of the 17 survey forms a subof this. All 17 tables should
have a unique id column, which equates to the main form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how? set cursor at field other than 1stfield upon form opening? 1
first form to open at the first unused ID # 7
database structure/design problems. please help 2
help: print multiple forms with a button on one form 6
help: button click event to open form to certain record 2
Access Newbie trying to create Access Database for survey data 0
dont save a form's fields until a button is clicked 2
help formatting/printing report to act as form 5

Top