Goto new record in Bound Form

  • Thread starter Thread starter Edward Harford
  • Start date Start date
E

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
 
Edward

Another approach would be to just use the <Add New> button to set the
DataEntry property to Yes on your bound form.
 
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
 
Back
Top