keeping form up-to-date (2000)

Topic

New Reply

Form1 based on Query1 on Table1. Query1 keeps all fields of Table1.
Button: make new record. This button opens dialog-Form2 Query2 on the same Table1. Query2 keeps all obligated fields of Table1.
After entering these obligated fields, dialogFOrm2 closes.

Problem: I can

Reply | Quote

Replies

In the on close event of form2, enter

Private Sub Form_Close()
Forms.Form1.Requery
End Sub

Reply | Quote

oops. you’re right.

Reply | Quote

right again. and is the case indeed in my real db!

thanks again!

Reply | Quote

Addendum to my previous post.
If you have combo boxes on you form add the line

Forms.Form1.cmbMyCombo.Requery

to requery them to.

Reply | Quote