getting a message box to display query results

[bw2601]

I have a IT Helpdesk database, and I have a query right now that i can type in a name (either first or last) or a system ID # and get a return. i would like to be able to put in the system ID and get the name of the user and vice versa. i would also like the return to come out in a message box. is this even possible, and if so how do i go about doing it.

thanks

 

[sfreeman]

Yes, it is possible with moderate VBA skills. Can't tell you how to do it without knowing more about your db. Look up the MSGBOX function in the Help file for more info.

Sam_F
"90% of the problem is asking the right question.

 

[dhookom]

Create a form and set its Record Source to your query. Then, just open the form for your answers.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]