Solved Form with tab control inside subform in datasheet view- how to update data

[lacampeona]

Hello
I have a form with several tab controls. Each tab control has a subform who is in datasheet view.

1.
From form frmGMKolutKapilare I choose ID record and then open a form with that specific ID.

2.
that form has several tab controls and On that form I have a button and I Use that button to copy (3) some fields from that specific ID 13 and enter new data.

4. I enter data in my new ID 14.

5.
How to automaticly update data when I finish entereing data in the form? Now i have to open and close and then I see the new record ID 14.

 

[theDBguy]

Try Requery?

 

[lacampeona]

Yes but where to put requery?
On which form? which event?
on close? on got focus? on current?
I try it and for now nothing ...

 

[Pat Hartman]

Since you want to requery a sibling subform, the code would be:

Me.Parent.nameofsubformcontrol.Form.Requery

Put it in the AfterUpdate event of each subform and run a separate requery for each subform you want refreshed.

PS, tabs have nothing to do with anything when referencing subforms and controls. They are ignored.

 

[lacampeona]

Hi Pat
How I run separate requery?hmmmm
Now I put it on the AfterUpdate event on my first subform? and now?

 

[Minty]

If you open the form as acDialog , the code on the calling form is paused until you close the first form.
So something like this in the frmGMKolutKapilare

DoCmd.OpenForm "yourSecondForm", acNormal, , WhereClauseGoesHere, acFormEdit, acDialog

Me.Requery

The Me.Requery won't happen until the second form is closed.

 

[lacampeona]

Hi Minty
what you mean with WhereClauseGoesHere. What I have to put here inside?
thank you

WhereClauseGoesHere

 

[Minty]

Can you show your code for how you are opening the second form?
It shouldn't need to change, you just need to add the acDialog part to it.

 

[lacampeona]

Hi
yes
this is
hmmmmm

Private Sub IDKolut_Click()
DoCmd.OpenForm "frmVnosKolutaKapilare", , , "IDKolut = " & Me!IDKolut, acFormEdit
End Sub

 

[Minty]

So the new version should be

Private Sub IDKolut_Click()

  DoCmd.OpenForm "frmVnosKolutaKapilare", , , "IDKolut = " & Me!IDKolut, acFormEdit , acDialog
  Me.Requery

End Sub

 

[lacampeona]

Ok
So the new version is

Private Sub IDKolut_Click()

DoCmd.OpenForm "frmVnosKolutaKapilare", , , "IDKolut = " & Me!IDKolut, acFormEdit , acDialog
Me.Requery

End Sub

what abut this you say earlier

I also have to use that? on the frmGMKolutKapilare Which event? hmmmm

DoCmd.OpenForm "yourSecondForm", acNormal, , WhereClauseGoesHere, acFormEdit, acDialog

Me.Requery

 

[lacampeona]

Ohhh
yessss is workinggg

thank you very much

 

[lacampeona]

Thank you both Pat and Minty
I first try Pat solution and didnt work hmmm or maybe I didnt make it correct
and then I try Minty solution and now is working.
thank you experts

 

[Pat Hartman]

My suggestion didn't work because you are NOT using a subform. Subforms are forms that are embedded in other forms. You are using what we refer to as a "pop up" form and Minty told you that to do this correctly, you open the "pop up" as a Dialog. That stops all the code in the base form after the OpenForm action is performed. The code in the base form resumes AFTER the "pop up" form is closed and THEN the requery runs.

Minty has you requering the main form which requeries all the subforms also. Since you told me you were running the code in a subform, I gave you the code to requery a specific sibling form. Which of course you didn't actually have and so obviously the code wouldn't work.

Do you now see the difference between an actual subform and a "pop up form"?

 

[lacampeona]

Hi Pat
yes now I see the difference between an actual subform and a "pop up form".

I saved both solutions in my "collection" so If someday I will need i have also that solution.
thank you again for you explanation.
you experts are so nice and full of knowledge. You are like doctors you know exatly what is the reason and solution.
thank you

 

[Pat Hartman]

I need to edit my previous comment.

If you call the popup from a subform, the Me.Requery is running in THAT subform and therefore will NOT requery the main form or sibling forms. Context is everything. If you call the popup from sfrmA and the list that you want requeried is in the CONTROL named sfrmB, your sibling on the main form, then you need to either requery the main form:

Me.Parent.Requery

OR

You need to requery the specific subform.
Me.Parent.sfrmB.Form.Requery

Remember, the name of the subform is irrelevant although if you used the wizard to build the subform control, the Control's Name property is likely = the actual name of the subform as seen in the Navigation Pane.