Form Navigation Keeping a Field Constant (MS Access 97)

[doover]

When working with forms in MS Access 97, which is the best way to move between forms keeping the same primary key field constant.

For example..

In questionnaire database, the question answers (Yes/No) are stored in fields q1-q20. Each physical answer sheet is stored on one record with Primary Key "Customer Number". Each customer should fill out a questionnaire.
The questions are held on forms. 4 in total, with 5 questions on each and as each form is finished, the user needs to click next to go to the next page - - hence keeping the customer number the same (this would keep the same record which then fills in the next 5 answers).

I have used the Microsoft Access Button Wizard, which sets link criteria and filters out what isnt being used, but after some time pulls up a run time error 2501.

Can anyone help me?

Doov

 

[Bowers74]

You might want to repost this (with a reference to this thread) in the Programmers>Microsoft: Access Forms forum to get more replies.

Please don't forget to copy the thread number into your new thread.

thread68-627346

If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!