I need help

[Douglas J Steele]

You need to set the combobox's LimitToList property to Yes, and put code in
its NotInList event.

See http://www.mvps.org/access/forms/frm0015.htm at "The Access Web" for
sample code.

 

[antonov]

Douglas,
I've copied the exampe in the "The Access Web" you told me...
the only thing is that I cannot open the form (Consignee) I need to open in
order to input the data needed....

 

[antonov]

Douglas,
I've copied the exampe in the "The Access Web" you told me...
the only thing is that I cannot open the form (Consignee) I need to open in
order to input the data needed....

 

[antonov]

Douglas,
I've copied the exampe in the "The Access Web" you told me...
the only thing is that I cannot open the form (Consignee) I need to open in
order to input the data needed....

 

[antonov]

Douglas,
I've copied the exampe in the "The Access Web" you told me...
the only thing is that I cannot open the form (Consignee) I need to open in
order to input the data needed....

 

[Douglas J. Steele]

What's at that site is just an example. The major reason I sent you to it
was so that you could see setting Response once the work is done.

Realistically, you probably want to scrap most of the code that's there, and
replace it with a DoCmd.OpenForm to open your form in Dialog mode so that
they have to react to it before they can go on. If you're comfortable that
your existing form is robust enough, you could simply set Response =
acDataErrAdded once you get control back from your form. Otherwise, you
might want to pass a value back to the routine so that you know whether or
not the form was successful.