470,596 Members | 1,695 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Refresh on mainform/subform


I would like someone to be able to help with the updating of data in a
lookup list in a subform. In short, is their a VB instruction that is the
equivalent of performing the action of going to the menu and selecting
Records and then Refresh?


To explain, based on a three table system where cars participate in rallies,
which is a many to many relationship, between the Cars and Rallies tables,
which is resolved by having a Races table.

I have a menu/switchboard which contains a button that opens a

On the mainform/subform is a button to open a form to allow the entry of a
new car into the Cars table.

I realise this button could be placed on the Menu form, but for better or
worse, if it is placed on the Mainform/Subform

and one then uses the New Car form to enter the details of a new car

and one then returns to the Mainform/Subform the new car appears in the
lookup list (which is the foreign key field in the Races table, i.e.
[Races.Engine #]), but if one repeats this process a 2nd time (or more),
without closing the Mainform/Subform, the 2nd car does not appear in the
lookup list. Selecting Records and then Refresh from the menu system updates
the lookup list. But I have tried numerous instructions in VB when returning
to the form, but I cannot find an instruction that matches Records and then
Refresh. And where does one place the instruction? On Activate, On Got
Focus, or ?????

I have attached a zipped file containing a sample database.

Thank you in anticipation for any assistance.


Nov 13 '05 #1
0 1917

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by news.shaw.net | last post: by
2 posts views Thread by S. van Beek | last post: by
4 posts views Thread by Yogi_Bear_79 | last post: by
3 posts views Thread by plgii | last post: by
18 posts views Thread by Robert Jacobs | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.