Hi,
I am using a combo box to select an appointmenttype. The appointment types are coming from another table. I am using a dlookup to also get the cost per hour from the same table.
Trouble is that in my subform, whenever I actually make a booking and select an appointment type, new records keep on going into the appointmenttype field in the tblAppointmentTypes.
Here are two screen dumps:
http://i40.tinypic.com/akyjx0.png
http://i43.tinypic.com/rkpjsx.png
What is causing this, and how do I prevent it?
Many thanks.
I am using a combo box to select an appointmenttype. The appointment types are coming from another table. I am using a dlookup to also get the cost per hour from the same table.
Trouble is that in my subform, whenever I actually make a booking and select an appointment type, new records keep on going into the appointmenttype field in the tblAppointmentTypes.
Here are two screen dumps:
http://i40.tinypic.com/akyjx0.png
http://i43.tinypic.com/rkpjsx.png
What is causing this, and how do I prevent it?
Many thanks.