G
Guest
There is a field in my database where users are required to enter the name of
the sales manager. The users have asked me to create fields for the sales
managers phone and cell phone numbers. What I did was:
1. Created a table with 4 fields (ID - Name - Phone - Cell)
2. Created a combo box to select the name of the manager
3. "After Update" phone field is populated by column2 and cell field is
populated by column3 of the combo box. Works great.
My problem is, whenever I open a record that contains an existing name in
the sales manager field, we get an error message
"The value you entered isn't valid for this field"
Even though the name is identical, I must delete and retype (or select from
the list) the name; and we get the error message ONLY when the field is
already populated.
What did I do wrong?
R Marko
the sales manager. The users have asked me to create fields for the sales
managers phone and cell phone numbers. What I did was:
1. Created a table with 4 fields (ID - Name - Phone - Cell)
2. Created a combo box to select the name of the manager
3. "After Update" phone field is populated by column2 and cell field is
populated by column3 of the combo box. Works great.
My problem is, whenever I open a record that contains an existing name in
the sales manager field, we get an error message
"The value you entered isn't valid for this field"
Even though the name is identical, I must delete and retype (or select from
the list) the name; and we get the error message ONLY when the field is
already populated.
What did I do wrong?
R Marko
