Update form when adding a new one

We have two computers working from the same table backend table.  We both are creating new records on the same form. Currently the only way we can see the other persons forms is to close our form and then re-open it. Is there a way to update so we don't have to do this? It is rather cumbersome having to close the form and then re-open it.

Thanks!

Chris
cansevinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
You can use a button to "requery" the form.
On the click event of the button, use code like his:

    Me.Requery
0
cansevinAuthor Commented:
Thanks Jeff... that is what I'll use.

I'm worried it isn't the "on click" event.

It is when we go to create a new memo. Is there a better place for that Me.Requery?
0
Jeffrey CoachmanMIS LiasonCommented:
You can requery at any time you want.
You can also requery any control/field you like.
(So along thoes lines, if you only want torequery the memo filed, ...you can do this:
    Me.YourMemoField.Requery

The kicker is that the "other new" record must have been committed to the table.

So you can do it on the GotFocus or Enter event of your memo control, ...but this may be problematic...

Better to add a "Create new memo button", ...to control this better.

But we are getting ahead of ourselves.
Please describe your form and its purpose, ...
Then describe the exact (step by step) user scenario... (and what you want to see or happen)

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
When you open a form, Access creates a recordset based on the table or query specified in the form's RecordSource.  Behind the scenes, Access will update the recordset if columns change and if rows are deleted they get marked as #deleted# in every column but NEW rows are not shown.  the only way to see new rows is to re run the RecordSource query and you can force that with:

Me.Requery

How critical is it that you be instantly aware of what the other person is doing?  I would use a button to force the requery rather than including it as a byproduct of some other event.  At least that way, you can control when it happens and do it as frequently as necessary but not so frequently that it is disruptive.

Keep in mind that if you are looking at a continuous or datasheet view form, when you requery the recordsource, the record pointer will move back to the first record which might be disconcerting.  If you don't want to reposition the recordset, you would need to save the PK of the current record and then after the requery, reposition the form to that record.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.