Not in list Event in cboBox

[Ayala]

Hi I have an unbound form with two unbound Combo boxes,
cboProjectName and cboOrderNo.

Each project can have many orders numbers.
If the users types a new project name I used the Not in
list event to add this new project. At this point it works
perfect.

My problem is when calling the not in list event of
cboOrderNo.
How can I tell the cbobox (of 3 columns where the first
column is the ProjectNameID, the second column is the
OrderID and the third is the OrderNo) to which projectID
corresponds the new OrderNo that wants to be added?
Until now the only result I get is opening the form where
the new order should be added but the ProjectNameID field
contains "(autonumber)" and the recordset is not
updateable..

Best wishes,
Ayala

 

[Wayne Morgan]

The ProjectNameID is probably the bound column of cboProjectName, so setting
the value to the value of the other combo box should take care of the
problem. The field shouldn't be an autonumber in both tables (the one used
for the row source for cboProjectName and the one used for the row source
for cboOrderNo).