Find a record using a TextBox & Button

ledis

New member
Local time
Today, 14:04
Joined
Jan 24, 2014
Messages
2
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
 
Tip:
USE a combo and the Control Wizard.
Look at the procedure designed by the wizard.
Adapt it to your textbox.
Remove the combo.

Use Access 2003 version for this.
The newer version will end up with a macro.
Why ? This is beyound my understanding, so you should ask Bill Gates :)
 

Users who are viewing this thread

Back
Top Bottom