>> I just want them to show up as they are added and not just after the
ADD form is closed. <<
before you do what Duane suggested and reset the RowSource, you may
need to refresh the tabledefs
currentdb.tabledefs.refresh 'refresh tables with record changes from all
processes and users
DoEvents 'do it now
and if you change the RowSource from code that is not behind the form,
you may need another DoEvents
respectfully,
crystal
~ have an awesome day ~
On 5/16/2017 9:15 AM, david.pratt@outlook.com [MS_Access_Professionals]
wrote:
> Trying for the third time to reply via the web and phone and struggling.
>
> Thank you all for the responses.
>
> Crystal, i am too far down the NAV road to turn back. Maybe i should use Tab for next application but i like the NAV user interface very much.
>
> Graham
> The records are being added. They show up in the list when the ADD form is closed and control is returned to the subform code. I just want them to show up as they are added and not just after the ADD form is closed.
>
> Duane
> I will try your solution as it seems very simple. Would you place this code in the AfterUpdate in place of or in addition to the requery?
>
> ------------------------------------
> Posted by: david.pratt
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar