Form is not requerying

  • Thread starter Thread starter midnite oil
  • Start date Start date
M

midnite oil

Hello,

There is a Search Form where the user can enter various search criteria.
They click on the Search button and this will launch the Search Results Form
which is a continuous form that displays a bunch of fields.

There is buttons on this form : Edit/View, Delete and Return to Search Form.
If the user enters Edit/View, it will load the Edit/Add Form (all controls
bound to tables), user then add/edit information and click the SAVE button
which will then close this form to return to the Search Results Form.

The SAVE button will call this function ReturnToSearchResults() cos. I need
to refresh the data on the Search Result form. Don't know why but it won't
requery the Search Result form. I have 2 other forms that is similar and
the requery works fine. Can't figure why this don't. I know this because I
edited the data in the Edit/Add form, click on SAVE to return to the Search
Result form.

Has anyone experienced similar situation...would appreciate your help in
this.

Private Sub ReturnToSearchResults()

Forms![Search Result].Requery
boolClickCloseWindow = True
DoCmd.Close acForm, Me.Name

End Sub
 
Back
Top