access, making a search and return?

[genocidex]

just something im looking into doing, and dont even know where to start. basically i need to type a number (in reference to a list). if the number exists, i need a return possibly a message or something to indicate a good. but if the number is not on record i would like an error message to pop up. the pop up for either of the 2 will have an "ok" button to bring back to the search again.

i was thinking of making a query using a similar form i used to prompt for searches, but i dont know how to make the returns the way i want, and the code i used would make the process take longer. also with the query method, it brings up a list instead of just the return.


any ideas where i could start?

im not skilled in any of the programming languages that might make this easy but if you point me in the right direction i am not apposed to learning the code

[sheamurai]

Are you just wanting to search a particular table, or are you creating reports?

I'm a very limited access user, but if you just have a table of values, if you just use the Find Next search, it either finds the value, and if it doesn't, it pops up a message that the value does not exist in the table.

Prolly too simple for what you are trying to do...