Data will not update unless I close form and reopen 
Author Message
 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 02:21:19 GMT  
 Data will not update unless I close form and reopen
Data changes are saved to the table when you move to another record or close
the form. There is an option on the menu bar Records|Save Record that will
save the record to the table without doing the above. The quick key for it
is Shift+Enter or you can do it through VBA by using "RunCommand
acCommandSaveRecord".

Once that is done, if refresh still doesn't take care of your problem you
may need to try requery. Using requery will move you back to the first
record on the form so you'll need to save a unique ID of the current record
and move back to it after the requery.

Wayne Morgan


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??



Sun, 28 Sep 2003 04:01:38 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Data will not update unless I close form and reopen

2. Data will not update unless I close form and reopen

3. Closing a form when other form is opening but reopening when all forms closed

4. Table (in form) Not Showing New Record Unless Close Form and Re-Op

5. Archive Query - result not showing unless form closed

6. Report is not updated with new data until form closed

7. Reopening a form from the forms on close event

8. reload form without closing and reopening the form

9. Refreshing chart data without closing and reopening

10. OE 6 will not reopen after it is closed


 
Powered by phpBB® Forum Software © phpBB Group