Access 2007 - DLookup Function

[Scott_66701]

I need help with the DLookup function in Access 2007. Here is what I have:

Table 1 named "Table1-Crew/Times" and the following fields in it:

Call Number
Run Number
Crew Member
Position
etc.

Table 2 named "Table2-Patient Info" and the following fields in it:

Run Number
First Name
Last Name
etc

I also have forms for each of these fields. What I am trying to do is use
DLookup to post the value of "Run Number" out of Table 1 and put it in Table
2 in the "Run Number" spot. I want it to do that for each record that is
inputed. How can I get it to do that? Also I have Run Number set as text
and not numeric.

Thanks

Scott

 

[Scott_66701]

Sorry typed part of it wrong. I am wanting to post the value from the
textbox from Form 1 (sourced to Table 1) and have what is typed in the
textbox appear in the Run Number field in Table 2 for each record entered.
Hope that makes sense.