If a new record is added, how do I update so it shows up on the form/subform?

[Daniel B]

I can add new records to my tables, but then when I open my form with a subform showing a table, the new record is not on there.

What should I do so that when I add new records to my tables, it will automatically update the new records into my forms/subforms?

Any advice or comments would be much appreciated!

Dan B

[dsatino]

Every time you open a form, it queries it's recordsource so it should always be able to present all data when you first open it. If you add records while the form is already open, you need to requery the form so it picks up any new data in it's recordsource

[Daniel B]

Okay, I think it is my queries that are the problem. If a new record is added, should'nt it appear in the query? When I add a new record, it does'nt even show up in the datasheet view of the query.

Does that mean my queries are not updatable? If so, what should I do to fix them?

[dsatino]

queries work the same as forms. When you open them, they'll show anything that fits the parameters. If you add new records while they are open then you'll have to rerun the query to pick up the new records.

If you're trying to input data via your queries, then the queries must be updateable, which in short, basically means they must have no aggregation.