continuous form - goto newly entered record when form closes

[sdel_nevo]

Hi All



i am having a real mental block with the following

i have three forms

frmCustomers
frmAddParts
frmEditParts

frmCustomers has tabs on it

"customer-list" and "Parts-list"

frmAddParts is the form where the user will add new parts into

the tab "Parts-list" has a continuous form on it, its source object is called "frmPartsList" the name is set to "PartsList" this lists all the parts in the system, it has a button that when clicked opens the form called frmEditParts

when i enter a new part into "frmAddParts" how can i get the continuous form to goto the newly entered partID? on the frmPartslist?

i can go back to the Partid when the form "frmEditParts" closes so that the continuous form does not always go back to the top

but i can't get my head around this when im adding records

any help would be great

many thanks

Steve

[ranman256]

Of you enter new rec in 1 form, then you must refresh the other form to see the new record.
either click the refresh button on the tool bar,
or
when you close the edit/add form refresh the list form...forms!frmList.requery

if the list resorts to the top, either GOToRecord ,or filter the list.

[sdel_nevo]

Hi Ranman256

The penny drops, many thanks mate, been looking at this for ages lol

Steve