I have a cascading combo which goes to a different table depending on the value selected in another table.
i want to set up a "NotInList" event procedure which will allow me to add something to the table if its not in the table.
what is the syntax for the RecordSet paramaters, so that it selects the current row source, so that its not static, adn the table which the data is added to will change if i change the combo box which controls the other cascading combo?
the syntax for a static recordset is as follows:
Set Rs = Db.OpenRecordset("Inspector", dbOpenDynaset)
how can i change the "Inspector" bit, so that it will vary if i chose something else in the combo box?
i want to set up a "NotInList" event procedure which will allow me to add something to the table if its not in the table.
what is the syntax for the RecordSet paramaters, so that it selects the current row source, so that its not static, adn the table which the data is added to will change if i change the combo box which controls the other cascading combo?
the syntax for a static recordset is as follows:
Set Rs = Db.OpenRecordset("Inspector", dbOpenDynaset)
how can i change the "Inspector" bit, so that it will vary if i chose something else in the combo box?
