Pulling data form a field on a datasheet

[tpowers]

I have a form that a user will scroll in and look for a certian record. when the user finds the record that they are looking for I have them double click on the that record and a 2nd screen comes up. I need to be a able to take the data in the primary key field on the data sheet and plug in into the new screen that just opened. I have tried to use the following code:

Dim varLoanNo As Variant
Dim varScreen As Variant
txtFormValue.SetFocus
If txtFormValue.Text = "D" Then
txtLoanNo.SetFocus
txtLoanNo.Text = Forms!FrmSentToSearchDetail!LoanNo.Text
End If
txtLoanNo.SetFocus
MsgBox txtLoanNo.Text

What am I doing wrong.

FYI.... I am using access 2000

 

[judgehopkins]

http://www.candace-tripp.com/access_downloads.htm

Go to this web site and download autofill.zip. When you extract it, convert it to Access 2000.

If I understand your question correctly, this is what you are trying to do.

Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.