Help New to Acces and Forms but quick learner.

[LG523]

Hello , I am new to Access and forums and thought I give this a try because I could really use some help.

I have to take two tables and create a form that will let a user in one box insert a idcode (text). Once the code is inserted in the text box I need a button below a empty text box that will read what the user inserts and find the record that goes with the code. The result will be displayed in the one box. Here is an example of what the form screen looks like.


(ID Code TEXT BOX) FROM TABLE ONE example-- (OOCAO)


(TEXT BOX FOR RESULT) (HR File for Northeast Divsion)

[ENTER BUTTON]




(ID Code TEXT BOX) FROM TABLE TWO


(TEXT BOX FOR RESULT)

[ENTER BUTTON]

Here is some facts for you.

1) Using Access 2007.
2) Dont know visual basic.
3) Have imported both files and created both tables.
4) I have created the form with unbound textboxes and a button.
5) I dont know how to make the button do what I need it to do.

I hope this gives someone enough to put me on the right track.

[orange]

Please see this free video tutorial
http://www.datapigtechnologies.com/f...earchform.html

[LG523]

Thank you very much. The tutorial looks as if it will be very helpful. However , I still dont see how to bring back the result of the search on the same form. Not switch to the table. For example in the video I would like to have one more text box that say results------( ) and inside I need the record that it found/ not switch to the table itself. Is that possible?

PS - WoW Thank you for responding so quickly.