Form Question

[Lissa]

Hi..

Does anyone have any clue why this would happen? I am still stumped on this one.

A user enters a new record through a form based on a 4 table query. The recently added record appears on the query but when the user runs a report linked to the form after adding the new record,
1) the newly added record does not appear in the report
2) when the user closes the form and re-opens the form, the saved record does not appear in the form.

A check on the queried table reveals that the record was saved to table.
Why does Access do that?

 

[CEH]

Does the report pull it's info from the same query as the form does? IS the form reopening in add mode? If not... do other records show in your form?

 

[Lissa]

Hi Curtis,

Does the report pull it's info from the same query as the form does?
Yes the same query is used

IS the form reopening in add mode?
I open the form using this argument: DoCmd.OpenForm "frmSummarizedRsrcData"
I'm assuming that's edit mode?

If not... do other records show in your form?
As the form is opened, all other existing records are displayed...


Thanks,
Lissa