W
Wendymel
This is a continuation of an issue from 5/28/09 with the same title.....
The reason I have the control source for the combo box as
"tblProjectData.ProjectManager" is because the record source for the form is
a query with several joined tables. The main table IS tblProjectData, but
there are numerous other tables, one of which is tblProjManager with a field
named ProjectManager. (I know...should have named it something different but
was to far along once I realized....).
Hence, the control source on the combo box with the specific name, to
differentiate the two "ProjectManager" fields.
So...having said all that, I have added a DoCmd.Beep to the original code
and it does not beep. I get the message that the name I add "is not
currently in the list. Do you want to add it?" which is what it is supposed
to do (On Not In List event). I then get a run-Time error '424': Object
Required. When I click Debug it points to the line of code we are working
with.
When I end the debugger I am back at the form with the field populated with
the name I just tried to add, but in the format "jsmith".
Thanks,
Wendy
The reason I have the control source for the combo box as
"tblProjectData.ProjectManager" is because the record source for the form is
a query with several joined tables. The main table IS tblProjectData, but
there are numerous other tables, one of which is tblProjManager with a field
named ProjectManager. (I know...should have named it something different but
was to far along once I realized....).
Hence, the control source on the combo box with the specific name, to
differentiate the two "ProjectManager" fields.
So...having said all that, I have added a DoCmd.Beep to the original code
and it does not beep. I get the message that the name I add "is not
currently in the list. Do you want to add it?" which is what it is supposed
to do (On Not In List event). I then get a run-Time error '424': Object
Required. When I click Debug it points to the line of code we are working
with.
When I end the debugger I am back at the form with the field populated with
the name I just tried to add, but in the format "jsmith".
Thanks,
Wendy