Programming "next appoinment" on to invoice form

  • Thread starter Robert Robinson
  • Start date
R

Robert Robinson

I have created a program that schedules and invoices clients for services
rendered. I would like to program an additional bit of information onto the
form, but am foggy as to how to go about it.

Often, clients will book appointments in the future, and I would like to add
a "Next Appointment is" date field.

I could see creating a box on the form which would attach to my appointment
table. By using SQL logic I could compare the dates for a customer to today's
date and have it return the next value in the list. Is this the most
efficient way of pulling the next date? Are there any pitfalls to this
approach (e.g., if a person has multiple future appointments)?
 
M

Marshall Barton

Robert said:
I have created a program that schedules and invoices clients for services
rendered. I would like to program an additional bit of information onto the
form, but am foggy as to how to go about it.

Often, clients will book appointments in the future, and I would like to add
a "Next Appointment is" date field.

I could see creating a box on the form which would attach to my appointment
table. By using SQL logic I could compare the dates for a customer to today's
date and have it return the next value in the list. Is this the most
efficient way of pulling the next date? Are there any pitfalls to this
approach (e.g., if a person has multiple future appointments)?
Click to expand...


If the client's next appointment is already entered in the
Appointments table, this I think the simplest way to display
the date on the form is to use a text box expression like:

=DMin("appdate", "Appointments", "ClientID=" & ClientID)

If you want to create the apponitment from your text box,
you'll need to explain more about the tables, their fields
and how you want things to behave before I could make a
meanungful suggestion. However, I do suggest that you have
an appointments form for this purpose.
 
Top