Formular synkronisering

Try placing this line of code BEFORE the line which opens the sub form

RunCommand acCmdSaveRecord

Looks like I need something else too, I'll have to tjek some more, but it seems like when closing the sub form it still does not save the data, cos when opening it again the fields are empty.

To control that the data match the post I use a criteria like this:

    stLinkCriteria = "[Personnummer]=" & "'" & Me![Personnummer] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Maby thats not a correct way to do it, and it disturbs?

Maybe I havent understood the question correctly!

If you are updating data on th emain form then normally I would expect the chnages to be saved when you press a button to open a sub form.

If you change data on a sub form and want to show these changes on the main form then you need to requery the main form BEFORE you close the sub form (FORMS!NameOfMainForm.Requery)

Well, I try to explain more detailed.

The mainform is open with some fields. I type the data in those fields and works fine so far, it saves automatically if I change post or close the database. Then I have some sub forms for additional information, called with buttons on the main form. The fields in these sub forms are ofcause empty.

Now I type data in those sub form fields (all fields are from the same table) and close the subform again. If I then reopen the same subform the fields has become empty again. Somehow it does not save the new data.

The workaround I can use, but which is not very usable, is first type data in the main form, then clik one post forward or backward or close and reopen the mainform - and first after that open the subform and type data in it's fields. Then it works as supposed.

So what I need is to make that sub form save the data on close down too, without having to close the main form first or go forward/backword in posts.

But maby the problem is of another type - there might be errors in my coding causing this (I don't get any errormessages though)

To me it sounds as though the record in the main form isnt getting written to the dB before the sub form gets opened.

So you must write the record in the main form using the line of code I gave, before you open the sub form.

If you cant get it working can you send me your dB so I can take a look?
ekspertenATsanthell.dk

AT = @

Hi Terry.

Thanks a lot for your help, it seems like I got it right now. I guess I only got it ½ right the first time.

Now my code regarding this looks like this:

    RunCommand acCmdSaveRecord
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "Andet"

But later I have this line to make sure it's the same post:
  stLinkCriteria = "[Personnummer]=" & "'" & Me![Personnummer] & "'"

So, when I tested the first time I did not get to "Personnummer" field which is one of the bottom filds, before opening the subform. I think that was the reason that the data from the subform wasn,t saved.

It seems to work now, so thanks again for your help!

super, thanks for the points