Prev: jumping data
Next: Main Form with a Subform with Check and Command Boxes
From: SueW on 16 Apr 2010 14:37
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


From: John W. Vinson on 16 Apr 2010 22:42
On Fri, 16 Apr 2010 11:37:01 -0700, SueW <SueW(a)discussions.microsoft.com>
wrote:

>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)?
--

John W. Vinson [MVP]
From: SueW on 19 Apr 2010 10:58


"John W. Vinson" wrote:

> On Fri, 16 Apr 2010 11:37:01 -0700, SueW <SueW(a)discussions.microsoft.com>
> wrote:
>
> >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)?
> --
>
> 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

 | 
Pages: 1
Prev: jumping data
Next: Main Form with a Subform with Check and Command Boxes