how do I update info that displays on forms and subforms?

[Daniel B]

In one of my forms I can enter in a new record and save it, and it will be in the original tables. Then when i open my form that allows you to scroll and look at each individual record, the new record saved in the tables is not there and it is the same in my subform.

Im guessing I need to run an update query to update the data in the form and subform, but I am not sure on how to go about that either.

Any comments or advice would be much appreciated!

Dan B

[gershwyn]

If your form is bound to the table being updated, there's nothing you need to do to manually make the data visible. If it's in the table, it should show in the form.

Do you have any filters set on your form that might cause it to ignore the new record? Is there any VBA code executing when the form first opens?