REFRESHING ONLY 1 RECORD ON CONTINOUS FORM

[SeanB]

Is there anyway on a form to only refresh or requery the record I have selected on the Form_Current instead of having to requery the whole set. I am not using Jet OLE ADP and it won't work like jet. Thanks

 

[downwitchyobadself]

Make your form unbound; use a combo/list box with all your form's key values as a search key, maybe add some custom navigation buttons; run the query to grab the data on the current event, and configure a way to save the data (like a button, or in navigation). If you're using ODBC an unbound form should probably load & save faster.