F
funkdrmr
Hi everyone.
On my form, I have 3 fields to manage supervisory information fo
personnel in my office. There is 1 combo box, and 2 text boxes.
When our office employees select a department in the combo box, I wan
the department's supervisor and phone number automatically filled int
the 2 text boxes (txtSupervisor and txtPhoneNumber).
What I've done is created a query, returning all of the columns from m
assignments table. I use that query to give the values in the comb
box, and fill in the text boxes using the "After Update" event on th
combo box.
This works well, except for the phone number part. I've played aroun
quite a bit with the form and the coding, and it seems that I can pu
any of the other columns into my txtPhoneNumber field, but when I tr
to put the phone_number column into the field, it just comes up blank.
Is this a formatting issue between the table fields and the form field
I've tried every combination I can think of, but still can't figure ou
why the phone numbers are the only data that CAN'T be displayed in tha
field.
Thanks in advance for any help
On my form, I have 3 fields to manage supervisory information fo
personnel in my office. There is 1 combo box, and 2 text boxes.
When our office employees select a department in the combo box, I wan
the department's supervisor and phone number automatically filled int
the 2 text boxes (txtSupervisor and txtPhoneNumber).
What I've done is created a query, returning all of the columns from m
assignments table. I use that query to give the values in the comb
box, and fill in the text boxes using the "After Update" event on th
combo box.
This works well, except for the phone number part. I've played aroun
quite a bit with the form and the coding, and it seems that I can pu
any of the other columns into my txtPhoneNumber field, but when I tr
to put the phone_number column into the field, it just comes up blank.
Is this a formatting issue between the table fields and the form field
I've tried every combination I can think of, but still can't figure ou
why the phone numbers are the only data that CAN'T be displayed in tha
field.
Thanks in advance for any help