Same Field, Different Form Page

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I'd like one field (the Contact's Last Name) to
automatically appear on the second page of my form...so
it is clear to the user that the additional information
still relates to this particular contact.

I added the field to the second page...and the last name
entered on the first appears...but only after I forward
and then back the record. Why? And how do I fix it to
immediately appear?

Many thanks,
 
Remember that when you are entering data into an new record, it is not saved yet. By advancing forward to a new record then returning to the last record you automatically cause Access to save the data to the table. If you are using a button to advance to your second page, add code to that button to save the record as you advance to the second page. In Access97 it would look like this:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
If the last name doesn't immediately show on entering Page 2, add a line of code to requery the control after the record is saved.
Hope this helps.

amcgaffic

----- Paul wrote: -----


I'd like one field (the Contact's Last Name) to
automatically appear on the second page of my form...so
it is clear to the user that the additional information
still relates to this particular contact.

I added the field to the second page...and the last name
entered on the first appears...but only after I forward
and then back the record. Why? And how do I fix it to
immediately appear?

Many thanks,
 
Back
Top