Content Update

[katiekat]

Hi!

I have 2 forms. One's a modular update form "add new", the other does pretty much everything else. If you add a reccord in the "Add New" form, the reccord doesn't show up until you close the other form and open it up again. How do I push the form to update the table on save of the "add new" form?

Spanks for the help!!

Kate Holy tek-tips batman!:-0

 

[JoeMiller]

In the AfterUpdate event of your form issue a requery command of the other form. This solution assumes that the other form is ALWAYS open when the add new form is...

[tt]
Code Sample
[forms]![FormToShowDataIn].Requery
[/tt]

HTH Joe Miller
joe.miller@flotech.net

 

[katiekat]

and if it isn't? Holy tek-tips batman!:-0

 

[JoeMiller]

If it isn't then you need a function to test if it is open, and then if it is open issue the command. Here's a function to test if a form is loaded, place it in any module.

[tt]
'Examines open forms and returns true or false value
'depending on form being open or closed.
Function IsLoaded(ByVal strFormName As String) As Integer
IsLoaded = False
Dim frm As Form
For Each frm In Forms
If frm.Name = strFormName Then
IsLoaded = True
End If
Next frm
End Function
[/tt]

Now modify the code I gave you before to this:

[tt]
If IsLoaded("FormToShowDataIn&quot Then
[forms]![FormToShowDataIn].Requery
End if
[/tt]

That should do it!

Joe Miller
joe.miller@flotech.net

 

[katiekat]

Thanks Joe! I really appreciate it!
:-D
Holy tek-tips batman!:-0