Hello,
I have a combo box that runs a NotInList event to enter new data into a table. When I run the event normally, it's fine, but, I also want the same combo box to be limited by another combo box on the same form. When I change the datasource to the query to limit the list, it won't allow me to update the table anymore. I understand the reason, but how do I get around it?
Basically, what I have is field1 that requeries (sp?) field2 and in field2 I would like to be able to select from the limited list or create a new entry if the one that I need is not in the list.
If anyone can help me, please do.
I have a combo box that runs a NotInList event to enter new data into a table. When I run the event normally, it's fine, but, I also want the same combo box to be limited by another combo box on the same form. When I change the datasource to the query to limit the list, it won't allow me to update the table anymore. I understand the reason, but how do I get around it?
Basically, what I have is field1 that requeries (sp?) field2 and in field2 I would like to be able to select from the limited list or create a new entry if the one that I need is not in the list.
If anyone can help me, please do.
