Find a record using a TextBox & Button

[ledis]

Hello, basically i want to type the ID(key) of a record table in a unbound text box and then by pressing a command button to be able to bring up that record (in form view). I do not want to use a combo-box.



So what do i write as VB code in the Private Sub mybutton_Click()

Table name is [ACTION_ID], ID field name is [ACT_ID] & text box name is [TEXT_BOX]

Thank you

[Bob Fitz]

Why don't you want to use a combo box

[ledis]

Hi thanx for the reply, I think i got a far as this point :

using this code on the button

Private Sub mybutton_Click()

DoCmd.OpenForm "ACTION_ID", , , "ACT_ID ='" & Me.TEXT_BOX.Value & "'"

End Sub

But this works if the [ACT_ID] cell is type TEXT (wont work if its NUMBER, would be cool to know what to add or remove in the code so i can use a NUMBER type cell)

and also can you help me with adding a "This ID does not exist" message if an [ACT_ID] that does not exist is looked up?

[Bob Fitz]

Cross post see: http://www.access-programmers.co.uk/...d.php?t=260356
Please don't crosspost without telling us. Please read the following link: http://www.excelguru.ca/content.php?...-cross-posters

If [ACT_ID] is numeric then you do not need to enclose the criteria in single quote, so try:
DoCmd.OpenForm "ACTION_ID", , , "ACT_ID =" & Me.TEXT_BOX.Value

[orange]

Will the user really know the "ID"???
You may want to test your theory before doing too much programming.

Good luck.

[ledis]

Im really sorry about the "cross post" never heard about it before , now i know.

Thank you for the help, im probably going to be asking more stuff here!

[ledis]

Hi, yep from what i understand they have all the data on paper even the ID and then they put it in the DB.
...im not sure they even now what they want yet :P, i think im going to be visiting this forum a lot more times.