Re: Form Requery Not Working

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm not certain, but I think it is not working because the user's
insisted on a "submit" button. When they hit submit, the screen
clears for more data entry. Then if the screen is closed, it doesn't
trigger the dirty option.

Any ideas given what I said are appreciated.
On May 15, 8:41 am, Mrstacy <sandpk...@xxxxxxxxx> wrote:
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/20080...Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Quantcast