MS Access, Data will not update unless I close form and reopen

Data will not update unless I close form and reopen

Author	Message
Andr #1 / 2	Data will not update unless I close form and reopen I have a form that lists invoice items based on a qry for the order number. I also have an invoice item number field which is used to put the item in order on the form. If I want to change the order of the items I change the invoice item numbers. I made a refresh button but the order does not change. If I close the form and open it they are in the correct order. How can I do a deeper refresh?? Thank you for your time
Sun, 28 Sep 2003 04:11:52 GMT

Tony Oakle #2 / 2	Data will not update unless I close form and reopen Quote: > I have a form that lists invoice items based on a qry for the order number. > I also have an invoice item number field which is used to put the item in > order on the form. > If I want to change the order of the items I change the invoice item > numbers. I made a refresh button but the order does not change. If I close > the form and open it they are in the correct order. How can I do a deeper > refresh?? > Thank you for your time I assume your using the refresh method? Try using requery instead Hope this helps Tony Oakley
Sun, 28 Sep 2003 18:26:59 GMT

Page 1 of 1

[ 2 post ]