P
pfm721
I have a main form frmVet, subform sfrmInfoSub, sub subform ssfrmAppointment
on a tab control TabCtl1. In the main form the user inputs an ID number. The
ID number pulls the consult number into sfrmInfoSub. The consult number pulls
relevant Appointments in ssfrmAppointment. My problem comes in when the user
moves sfrmInfoSub to a new record to enter a new consult number.
ssfrmAppointment clears like it is ready to recieve a new appointment but
when the user selects the drop down for the appointment type it gives this
message
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."
What is confusing about this for me is that all of the forms/subforms work
fine on the first record for a client. Everything else works fine on the
second record until you get to ssfrmAppointment.
Any ideas or help would be greatly appreciated.
Patrick
on a tab control TabCtl1. In the main form the user inputs an ID number. The
ID number pulls the consult number into sfrmInfoSub. The consult number pulls
relevant Appointments in ssfrmAppointment. My problem comes in when the user
moves sfrmInfoSub to a new record to enter a new consult number.
ssfrmAppointment clears like it is ready to recieve a new appointment but
when the user selects the drop down for the appointment type it gives this
message
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."
What is confusing about this for me is that all of the forms/subforms work
fine on the first record for a client. Everything else works fine on the
second record until you get to ssfrmAppointment.
Any ideas or help would be greatly appreciated.
Patrick