M
MarieM via AccessMonster.com
I have subform on a Main form with two combo boxes and a text box.
I have code attached to the first combo box's After Update property which
limits the entries in the second combo box. Once the user selects an entry
from the second combo box, the phone field populates with the related phone
number. This is all working great.
However, when the user selects an entry from the second combo box that does
not have a related phone number entry, I receive a Run-time error - Field
'Phone' cannot be a zero-length string.
The Phone Number field is not always populated.
I removed the input mask I had on the field and changed the Allow Zero Length
property for the Phone field in the table to 'Yes', however I am still
receiving the error.
Any ideas would be greatly appreciated!
Marie
I have code attached to the first combo box's After Update property which
limits the entries in the second combo box. Once the user selects an entry
from the second combo box, the phone field populates with the related phone
number. This is all working great.
However, when the user selects an entry from the second combo box that does
not have a related phone number entry, I receive a Run-time error - Field
'Phone' cannot be a zero-length string.
The Phone Number field is not always populated.
I removed the input mask I had on the field and changed the Allow Zero Length
property for the Phone field in the table to 'Yes', however I am still
receiving the error.
Any ideas would be greatly appreciated!
Marie