Using Access VB code, how can I prompt the user to enter text?

[F15]

Using Access VB code, I would like to prompt the user to enter a number string which I will use several ways. First, I will use that string to delete any records matching the string, and then locate a file to import new data. What is the VB code to create the user interface box and how do I capture what the user has typed?

 

[JeremyNYC]

First, you have to decide if it's numeric or string.

Assuming it's text, do this:

Function RespondToMe()
Dim strResponse As String

strResponse = InputBox("Enter the string.&quot
MsgBox strResponse

End Function

The message box is just there to hold the place of what you'll do with the response.

jeremy
=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[F15]

Thank you very much. I figured that it should be quite simple but I just couldn't find it in my reference material. I really appreciate your help.