refreshing or requerying a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form witha combo box with a double-click event.which opens a newer
form..i would like the original form to refresh or requery after the newer
form closes. Right now i have it just requery the original combo box but its
a delete query so i get nothing but #deleted# in all the fields in the
orginal form after something gets deleted. Is there anyway to refresh the
whole original form?

Thanks-
 
Try adding a close button which "Unloads" and then loads
the form you want to refresh. This could be slow depending
on your form though. It would be something like this:

cmd_close_click()

unload "formname"
load "formname"
'code to close current form

end sub
Check the syntax of load and unload.
 
well in the new form form that deletes the selected value can i put it both
inside the on click of the close button and the ok button??

Thanks-
 
Back
Top