I'm trying to requery a subform and keep getting the message "you must save current field before running the requery action". This is happening because before I requery the subform I'm passing a value onto it within a field called "STATUS". How can I get around this error (i.e. get the field to save?).

Ryan.

After passing your data try a Me.Refresh and see if that helps. You may not need to do the requery.... (I am really guessing here!)