query & modifying table from form

[Chris L]

I have a table that has the following fields
ID, Num, Type, ReportTo
ReportTo has a value of certain ID.

Then I have a form named fm_List with a combo box named cmbType & cmbReportTo.
with cmbReportTo displaying the Num field generated with the following query:

SELECT tbl.ID, tbl.Num FROM tbl WHERE (((tbl.ReportTo) Is Null) AND
((tbl.Type)=[Forms]![fm_List].[form]![cmbType])) ORDER BY tbl.Num;

The user can input certain Num into the cmbReportTo combo box. if the Num is
not in the list, then I want the NotInList event handler to search the
corresponding ID of the Num entered by the user and set the ReportTo to that
ID number.

Can somebody guide me on how can I implement this?

 

[Ken Snell [MVP]]

Answered in another newsgroup where you posted the same question.