Multiple Forms saving to 1 table

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

Guest

I have a survey I've developed but because of the number of questions I've
created 6 different forms to ask the questions. When i'm entering the data
and go from one form to another thru a command button to OpenForm it writes
another record to the table with just that forms information.

Is there a way to have multiple forms access 1 record but fill in just the
data that pertains to that particular form ?

I'm sure I have done this in the past... but I can't remember what I've
done. Any help would be greatly appreciated!
 
I have a survey I've developed but because of the number of questions I've
created 6 different forms to ask the questions.
Click to expand...

It sounds like you've made the very common mistake of "committing
spreadsheet upon a database" - do you have one FIELD for each
question? If so, you're going to run into problems! A much better
design is to use three tables: Surveys, Questions, and Answers, with
relationships Surveys -1:n-> Answers and Questions -1:n-> Answers.
See Duane Hookum's At Your Survey sample database for an example:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'
When i'm entering the data
and go from one form to another thru a command button to OpenForm it writes
another record to the table with just that forms information.
Click to expand...

Well... yes. That's what you're asking it to do. Open another form and
save the information from this form.
Is there a way to have multiple forms access 1 record but fill in just the
data that pertains to that particular form ?
Click to expand...

If you really really want to use this non-normalized table design,
realizing that there are alternatives, then I'd suggest that you use a
Tab Control on the form rather than multiple forms. This will give you
almost unlimited (well, 729 is the limit on controls I believe) screen
space.

To open a second form at a particular record, use the WhereCondition
argument in the VBA code that opens the form. The command button
wizard gives you the option of opening the form to a particular
record; if it doesn't for you, please post your code, it's easy to
add.

John W. Vinson[MVP]
 
Back
Top