Create new record and then set focus to it in a subform

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Was wondering if someone would lend a hand is trying to accomplish something
that I have been trying to get to work for several hours now.

Down and dirty version:
MainForm [frmCustomers] subForm on [frmCustomers] named [subCusDet]. I use
[subCusDet] as an unbound subform and change it's SourceObject to fill
several different forms depending upon the button that the user have pushed.
[frmEquipOwned] is one of the Forms I use to fill [subCusDet] and it displays
Equipment owned by the customer. The customer can own more than one piece of
Equipment. From the subForm I have a 'NEW' button that opens [frmEquipment],
which allows the user to add a new piece of equipment for the customer. At
Close of the [frmEquipment] I have [subEquipOwned] being Requeried. All works
well but would like it to do one more thing. When [frmEquipment] closes and
Requeries, I would like for Form![frmCustomers]![subEquipOwned] to go to the
new record that has just been added. Was wondering if someone would lend a
hand in getting this last detail taken care of.

I have searched the forum and found similar circumstances but not quite the
same scenario as mine. I tried to massage some of the code I found but I'm
afraid I'm not smart enough to figure it out.

TIA,
Shane

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200602/1
.

Quantcast