Goto new record in Bound Form

[Edward Harford]

I have a bound data Form with "Add New" button - opening an Unbound Form.
Data is entered up and saved as new record to recordset which is then
closed.
Bound data form is then requeried.

I want to then go to the record in the original form that I have just added.

Any ideas gratefully received
Edward Harford

 

[Jeff Boyce]

Edward

Another approach would be to just use the <Add New> button to set the
DataEntry property to Yes on your bound form.

 

[Simon Shaw]

You could write the primary key of the new record to an unbound field on
your parent form (the bound one).
Then you might programatically move to that record after the requery.

Not sure why you are using two separate forms for this though? Are the
contents very different? Locking / unlocking individual fields from the
OnCurrent event might be easier.

Simon Shaw
Netfare