Pop Up Input Boxes

Hi Guys,

I posted on this forum a few months ago chasing a solution and still haven't found something. Is ther any way in vb that you can prompt the user to input a number? I was posted the code below to try and help. In the example below, i would like to be able to have the end user input the first and last numbers (11000 and 11100, in the example) in a pop up box, as these vary, not have them defined in the code, is this possible? In the database, the first and last numbers in a string are all that is needed and the db fills in the gaps, so to speak


Const MyTable As String = "YourTableName"
Const MyField As String = "YourFieldName"
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim intCounter As Integer
Set db = CurrentDb
Set rs = db.OpenRecordset(MyTable)
For intCounter = 11000 To 11100
rs.AddNew
rs.Fields(MyField) = "TP" & intCounter
rs.Update
Next intCounter
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing

Thanks for any help you can give. I hope it is pretty straight forward, as my vba skills are fairly limited.