filters and message boxes

[emshim]

Hi,

I am trying to do a search that will find all the records matching the customer number typed in another box on a different form. When i search a valid customer number, i.e. a number which is in the table, it will find the correct record, and close the other form. The problem is, if the customer number does not match any of the records in the table, i want a message box to display, and then go back to a different form which allows the user to delete the details manually.

Anybody got any ideas on this? I can give you more information if needed.

Emily

 

[neileg]

If I was you, I'd use a combo box that is populated with a list of existing numbers instead of a free entry text box. This way, the user can only select a valid number.

 

[emshim]

problem is, there could be thousands of numbers, there are alot of customers! Also, due to one customer having possibly more than one item, their number may be able to be found more than once. This is fine for the search, as there are say, 3 records in the filter. But how would i delete all records in the filter?

Emily

 

[neileg]

I'm not sure I fully understand the question! But here goes...

I would base the combo on a query that extracts the valid customer numbers and set the unique values property to yes so that there is only one instance of the number. The native properties of a combo box is that you can type the value you want in a list and it will 'zoom' to the value as you type. You don't have to click and select on the list.

I would then use the customer number as the criterion in a query to select the customer records.

If this doesn't answer your question, please let me know.

 

[emshim]

i think that may work, ill have a go and let you know!

Thanks

em