Requery or Refresh

[bmac]

I have a Main Menu form that brings me to a data entry form
On Click it has the macro: “macGofromMenu_toFormâ€

This macro consists of 2 queries.
Query1 – Delete query to remove records where Field1 = 0
Query2 – Delete query to remove records where Field2 that has the word
“delete†in it

My issue is this. When I go back into the form and page back through the
records I see the #delete# in some of the fields that are to be entered.

What am I doing wrong here.

 

[Maurice]

You don't do anything wrong here but you should place a requery of the form
after running the queries because the source of the form has been changed and
should be 'refreshed' (how strange that may sound)

 

[bmac]

If I understand you correction, what you are saying is to add to the macro a
requery function to the query behind the form?

 

[Maurice]

Exactly.
--
Maurice Ausum

If I understand you correction, what you are saying is to add to the macro a
requery function to the query behind the form?

 

[bmac]

oh my!! how easy was that...
it works great Maurice )
thanks -

as always, this is a wonderul source to come to for advice..

 

[Maurice]

Often the hardest things that keeps you halted are the simple things
Glad i could be of help.