New to access need help linking forms

[hch1970]

Hello,



I am new to access, in a temporary job for 6 months. I am a long way from home and my documentation set and I have no colleagues that use the product at all. SO here is the issue, I have a long survey to enter. It appears to be too long for a single form in access. If I divide it into 2 forms, I would like to some how link the 2 forms either by putting a button (or two) on the bottom of the form that saves the current information and advances to the new form (the rest of the questions) on the same record. Or somehow create a form that combines the two.

Any advice would be greatly appreciated.

Cheers,
Hedy

[RayMilhon]

Need more information.
What is the data structure?
How many questions are on your survey?
Are there any groupings to your survey?

[hch1970]

Hi, There are 36 questions, 10 with check all that apply. For entry purposes I have separated them into separate Yes/No questions. With those there are about 80+ questions (I have not counted precisely). I have no groups and all the information is stored in a single flat table. I don't know how to group, but if I did, I would probably group the multi-part questions.

Cheers,
Hedy

[hitesh_asrani_j]

I can only help you in getting the from Form1 to another form but cannot help you as in how u can save the values..

So here it goes...

In the end of the form create a button and in VBA code builder, pLease insert the following line under the respective button function.

DoCmd.OpenForm "Form Name" , acNormal


try this and let me know...

[hch1970]

Thanks for the suggestion, I put buttons on the screen to save the one I am working on and open a few form, but can't get it to open on the same record.......

In the meantime, I abbreviated some of the questions and got it to fit on 1 screen, so in a way the problem is solved for me for the moment, but I am still puzzled by it.

[RayMilhon]

Here's what I would do based on the limited info given. First I would copy the existing form just in case the changes don't work. On the new copy at the top of the form put the data elements that identify the survey. example. Survey ID, Date Person taking the survey if tracked. That should take up 15 to 20% of your form at the top. Next Below that put in a tab control. set it to 6 pages to start. Put as many questions as you can on each tab.

[hitesh_asrani_j]

GR8 reply Ray..
yes u can use the Tabbedform for this so that the person has to just change the tab for next questions