Refreshing a forms record source

[bgreen]

Hi,

My Issue:

I have a data entry form (form1). When user is done entering their data they press an export button. This button opens another form. This new form (form2)has another command button which preforms several steps, creates a report, updates some tables, removes data from backend table which was entered from form1. When the steps are complete form2 closes. My issue is when form2 closes the record navigator does not refresh and still thinks there are several records still. You are able to scroll back but all fields display #DELETED. How can I refresh this form? Or requey the record source?

 

[PHV]

What about simply this ?
Me.Requery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bgreen]

I figured it out. I had to put in the forms ok button click sub code like the following.

Forms![form1].Form.Requery