Update Field on Form

  • Thread starter Thread starter Rubie
  • Start date Start date
R

Rubie

Hello,

How do I get a form that is based on a table to update a field without
closing and reopening the form?

Any help would be greatly appreciated.
 
Hi Rubie,

Not exactly sure what you mean but I think you want to refresh the data sort
of speak. Pleace a button on the form and in the OnClick event of the button
place Me.Requery and save. That should do it.
 
Thanks Stockwell.

I tried that but got an error message "that said it could not find the
macro." My form has four fields: 1. the manual data entry box, 2. the
percentage calculation box and the other two are based on a table. I want
the two that are based on the table to auto fillin the data everytime that
the table is updated without having to close and open the form. Any thoughts
 
Back
Top