Update a Form

[ahkleine]

Hello everybody



My problem is: I have 2 MS Acces forms opened in my application. The first form is a form in table style. The second form is a pop up form. In the first form there is a button to add a record and opens the pop up form. The problem is: when I add a record I want that access immediatly shows the new record in the first form. I have tried to do this with a timer in the first form. But this is not very nice. VBA command REQUERY does not work, even Repaint, Rfresh does not work. Who can tell me the solution

Regards Albert

[pbaldy]

Requery should work. Where did you have it? I'd try either in the code that closes the second form or the activate event of the first.

[ahkleine]

Requery should work. Where did you have it? I'd try either in the code that closes the second form or the activate event of the first.

In the propertysheet of the form I put the next vba code:

Private Sub Form_Activate()
DoCmd.Requery

End Sub

I Put the same code in the buttom that close the second form (the pop up form)

both dos not work in my forms

[June7]

Record entered on popup form must first be committed to table. Record is committed when: 1. close table/query/form; or 2. move to another record; or 3. run code to save.

Show code that opens the popup form.

Example from my db:

Private Sub btnEdit_Click()
DoCmd.OpenForm "EditSubmit", , , , , acDialog
Me.Refresh
End Sub

acDialog suspends code execution in the main form until the popup form closes. Code execution resumes with the Refresh (or Requery) of the main form.

[ahkleine]

June7

It is working. Thanks for your help

regards Albert Kleine