form not updating after data entry

[chrisd49]

Hi
Can any one help me with a quickey. I have a form which shows short details of a building ie name town postcode etc. I have another form with 3 subforms to be able to enter new details of a building, the new client and the new agreement. This works well and is feeding the new data into the correct tables. When I reopen the short detail form it doesnot display the new records. I have a short piece of vba which allows ne to see the full details of a site when I click on the site name.
A quick reply would be much appreciated.
Thanks
ChrisD

 

[CraigDolphin]

This may be offtrack but for what it's worth, are you closing then re-opening the short detail form? Or simply masking it invisible the having it become visible?

If the data is correctly entered into the tables and is present when the form opens, then it should find them if those tables (or derivative queries) are bound to that form. If you are not actually closing the form between views, then maybe you need to try something along the lines of Form!FormName.Requery to requery the recordet.

 

[Jonathan Kok]

Make sure the new record in the detailed form is saved before opening the short form (docmd.runcommand accmdsaverecord)