Re: Form Requery Not Working

Didn't work again.

I should have said this earlier, but the code works when I attach it
to a button. However, if I allow the user to click the x to close the
form, it won't work. I may end up not allowing them to close the form
with an x.
On May 15, 12:38 am, Maurice <Maur...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Maybe you have to set the focus to the form first if you are closing from an
other form then the form you are referring to. Just a guess but give it a
try...

so:

If CurrentProject.AllForms("Frm_Main_Menu").IsLoaded Then
  Forms!Frm_Main_Menu.SetFocus
  Forms![Frm_Main_Menu].Requery
End If

hth
--
Maurice Ausum



"Mrstacy" wrote:
It is a query

On May 14, 4:47 pm, "AkAlan via AccessMonster.com" <u18147@uwe> wrote:
what are you using for the Frm_Main_Menu recordsource? Is it being loaded
dynamicaly from another form or is it bound?

Mrstacy wrote:
Didn't work :-(

try using refresh and not requery. This works for me.

[quoted text clipped - 21 lines]

- Show quoted text -

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200805/1- Hide quoted text -

- Show quoted text -

.