Access2000: Data population in forms

Hi guys,

How do I pass one form field to do a search/query in another table and display that field in another form on click of a button. (Data Duplication)

Scenario:

table1 fields:

ID = 1 (P.K)
Name: Romeo
Surname:Surname

Table2 fields:

ID = 1 (ref key)
salary = 1000
Dept = IT

And you have a form that displays name and surname and there’s one button that when clicked displays the salary and department in another form for romeo mabasa.

Hope this makes sense…

Please help