Help

[Branagan]

I have made a query where u search for a reference number and it displays certains information linked with that reference. When i enter a reference number that isn't on the database it just displays an empty table. Is there a way of stopping this and just maybe displaying a message box saying "sorry that reference number isn't on the database" with an OK button or something similar.

Cheers in advance.

 

[Rich]

Use a combo box to select the available numbers from your table, if you set the limit to list to yes users can't enter an invalid number