Access 2007-Duplicate Record Field Capability

S

SueW

Sr. transportation appointment database. The form to schedule appointments
has a combo box that completes the client, address, city, and homephone
fields as requested by the end user. Added Find and Duplicate record buttons
so end user can find an appointment and duplicate the record to schedule the
return trip. Buttons work great except that on the return trip record end
user needs to type in the address the client is coming from and this not
possible because it is already populated from the combo box. Is there any
way around this?

Thanks for your attention.

Sue
 
J

John W. Vinson

Sr. transportation appointment database. The form to schedule appointments
has a combo box that completes the client, address, city, and homephone
fields as requested by the end user. Added Find and Duplicate record buttons
so end user can find an appointment and duplicate the record to schedule the
return trip. Buttons work great except that on the return trip record end
user needs to type in the address the client is coming from and this not
possible because it is already populated from the combo box. Is there any
way around this?

Thanks for your attention.

Sue


What's the structure of your table? What's the current code in the duplicate
button? What does the combo box have to do with anything (since I'd presume it
should be creating a new record in the table, rather than doing anything on
the form)?
 
S

SueW

John W. Vinson said:
What's the structure of your table? What's the current code in the duplicate
button? What does the combo box have to do with anything (since I'd presume it
should be creating a new record in the table, rather than doing anything on
the form)?
--

John W. Vinson [MVP]
.
tblSchedule
ScheduleID-AutoNumber-PK
Driver
Day
AppointmentDate
PickupTime
SeniorIntakeID-FK (PK in Senior Intake table)
AppointmentTime
AppointmentNotes
Destination
ReturnTime
ReasonforTransportation
Cancelled
WhoCancelled
NoShow
UnabletoCancel

Current code of Duplicate button-On click-embedded macro
Combo box is completing fields from the SeniorIntake table in the form as
part of the appointment record. The end user requested when selecting a name
from the Senior Intake table the name, address, city, and home phone number
automatically populate.

Appointment by Date Query and Report:
tblSchedule
Driver
Day
AppointmentDate
PickupTime
AppointmentTime
AppointmentNotes
Destination
ReturnTime
ReasonforTransportation
Cancelled
WhoCancelled
NoShow
UnabletoCancel
tblSenior Intake
First
Last
Address
City
HomePhone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top