By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Refresh on mainform/subform

P: n/a


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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.