If record not found through combo box... (1 Viewer)

[wasim_sono]

I am using combo box on my form through which the specific record was found. the problem is that if required record not found then combo box shows a particular record. I need that if record not found then combo box should be empty and related sub form should also be empty or showing null record.

Thanks.

Wasim

 

[Fifty2One]

Set the Data Limit to List property of the combo box to Yes.
There is a Not in list event that you can use for conditions if the user tries to select a non existant choice like a MsgBox saying record not good.

 

[wasim_sono]

Dear Fifty2One

I got it as I required but there is still a problem. The main form and sub form as well still showing a particular record which confuse the user. The user thinks that the combo box retrieve the data.

A screen shot is attached for reference.


Thanks.

Wasim

 

[wasim_sono]

Dear All

I'm still waiting for reply. Please try to solve the problem.

Regards.

Wasim

 

[suepowell]

Hi,

When you use the not in list event to put up the error message, could you set the main form to go to a new record, can't remember the syntax but
I'm sure it is in the help somewhere.

Sue