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

Lori,

If the new record does not show up it might be because it does not meet the JOIN conditions of your views. Are you sure you have all your keys set up before your tableupdate()?

José