Requery Problem!

[pgp]

Hi,

I have a ReviseQuote Main form with quotenumber & revision
number fields along with other info about the quote.
On this main form, I have a subform which lists all the
items that were quoted with this quotenumber & revnumber.

Mainform info stored in quoteheader table
subform info stored in quotelineitem table

When I open this revisequote form, enter quotenumber and
revnumber - it shows all the information about the quote
on the mainform and info about items on the subform.

When I double click one item on subform, it opens a new
form displaying all detailed info about that particular
line item. Say I revise some info on this new form.

Once I make chaanges, I click on save button on new form.
This creates a new record in quotelineitem with same
quotenumber but with new revnumber.

Now the subform on this mainform doesn't show the changes
I made. yet it shows the lineitem details for my old rev
number.

I tried Requerying the subform when I add the new record
to quotelineitem table, but in vain. The problem here is
that when I save the changes, I create a new record
instead of changing an exisiting one?


I would appreciate any input/suggestion
Thanks in advance