Lori,

Do you commit the data from the form to the table with a TableUpdate() before you requery the view?

>I am displaying a view as a grid on a form. The view combines data from several tables. I do have no data on load set when I load my form, and I do a requery on my view. My problem is, when I add a record on that form to one of the tables that is displayed in the view, (only for the first record added), the record is not displayed in the grid when I do a requery. The record, of course, does get added, but it is not visible until you get out and back in to the form. When you add additional records, they appear right away. I'm guessing this is a work area problem, but I'm not sure how to get around it.