Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Message Box

Status
Not open for further replies.

Goodloe

Programmer
Sep 4, 2001
25
US
Access 97 Message Box

The form I'm working with has an Option Group with 4 options. Among the options is an Employee Name. After the Employee Name option has been selected, I will press the ok button. Upon pressing the ok button, a parameter box will appear requesting that a Last Name be entered. When entering the name, if the name is mispelled, or if the name isn't in the table, I would like a Message Box to indicate Record not Found.

This form is based on a query called qryEmployeesSalary, and parameter set to Enter Last Name.

I was previously advised to use an Input Box to enter the name. Is it possible to use the msgbox as oppose to the Input Box to enter the name, or is this a situation where we the Programmers have limited control over the msgbox, and how we want it to function?
 
Input Box is the beast you need. The message box is the "Make A Statement" quivalent of the Input Box "Get A Value".

Inputs == InputBox
Outputs == MsgBox


 
Thanks, you're right, I should have known that.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top