I
InternRyan
I have a combo box and a couple other fields in a subform. The combo box has
a not in list event which works fine. I can cut and paste one record from
excel or another table into the form and it works fine. If the name(whats
goes in the combo box) doesn't trigger the not in list then I can cut and
paste however many and it still works. The problem is that if I then try two
or more that do trigger the not in list event, I get an error. I've been told
I shouldn't rely on that as an input method anyway but I'm here for the
summer and want to leave it in an as easy as possible form since there is no
one here who knows access....
I was thinking that maybe I needed either an extra line in the not in list
event code or code in the after update event but not sure what that would be.
Ryan
a not in list event which works fine. I can cut and paste one record from
excel or another table into the form and it works fine. If the name(whats
goes in the combo box) doesn't trigger the not in list then I can cut and
paste however many and it still works. The problem is that if I then try two
or more that do trigger the not in list event, I get an error. I've been told
I shouldn't rely on that as an input method anyway but I'm here for the
summer and want to leave it in an as easy as possible form since there is no
one here who knows access....
I was thinking that maybe I needed either an extra line in the not in list
event code or code in the after update event but not sure what that would be.
Ryan