Få form til at skifte til næste post ved ændring i en anden fom

If the two forms are related then WHY dont you link them? Then it all works automatically!

When you say "anden formular i" then I assume it is a sub form.

Ja jeg mener en Sub-form :o)

Spørgsmålet hænger sammen med http://www.eksperten.dk/spm/410624.

Jeg forsøger at løse problemstillingen ud fra dit svar. Jeg har placeret en formular med tblSvar i en formular der viser spørgsmålet. Ideen er så at når jeg har tastet et svar så vil jeg have hovedformen til at skifte til næste spøgsmål...

Hoved- og underformular hænger jo også normalt sammen omvendt, dvs sådan at hvis man ændre i hovedfomularen følger subform med. Jeg ønsker at ændre i subform og få hovedformularen til at følge med....

but you havent accepted my answer in your previous question!

Sorry, jeg ville lige se om jeg kunne få det til at virke, ordentligt - ellers skal jeg jo til at oprette spørgsmålet igen

Why dont you place a button on the FOOTER of the main form. When the person is finished entering data in the sub form they PRESS the button on the FOOTER (of the main form)

In the code of the button you use

DoCmd.GoToRecord , , acNext

and because it is on the main form then you go to the next record of the main form. The user can NOT see that th ebutton is on the main form and also it saves the record in th esub form which is on the detail.

In Access there is a property on the form called "Cycle" it is normally set to "All Records" set this to "Current Record" on the sub form. This will stop you moving to a new record in the sub form. So you will have to press the button to go to the next question (category)

terry > Tak, det virkede, mange tak :o)