Sub Form Problem

[Don Rountree]

I have a continuous subform that is used as an order
guide. Each time the main form is opened, I run a delete
query to delete the previous order and then I run an
append query to rebuild the underlying query with a
refreshed order guide. Everything works fine except
this. The first record in the continuous subform shows
the data of the first record. All the remaining records
show the word "Deleted" in all the fields. I imagine I
need to requery the form somehow. That's just my stupid
guess. Can someone set me straight and tell me what code
I need to add to my Onload property to get all records to
populate properly? Thanks in advance.

Don Rountree

 

[Gary Miller]

Don,

Before anyone tries to address the technical issue that you
are concerned about, my curiousity begs the question of why
you are deleting all of the history for a given order? Would
you not want to keep a record of this?

Gary Miller
Sisters, OR

 

[mcnews2k]

i've run into this problem a few times.
it works best for me if i delete when i close the form rather than when it's
opened.