I have two tables:
tCon: tTrans:
ConID TransID
EnvNo EnvNo
Name Money
Desc

Basically its a form(works on tTrans) with a subform(works on tCon) in it and what I need it to do is when I type in a EnvNo, after I lose focus with it I need it to display below, where the subform is the informaiton for that EnvNo account(displays Name and desc). How can I go about display that. Here is what I have but I am not sure how to send the id so that it can be displayed in the subform which is part of my main form.

Private Sub txtEnvNo_LostFocus()
On Error GoTo errhandler
    Dim strConId As String
    If txtEnvNo.Text <> "" Then
        intEnvNo = txtEnvNo.Text
        strConId = DLookup("[ConID]", "tCon", "[EnvNo]=" & intEnvNo)
    Else
        MsgBox "Please input a EnvNo"
    End If
Exit Sub
errhandler:
    MsgBox "Record does not exist"
End Sub

If you click on the main table, and then click autoform, it will create a linked main form and subform.

Then use the combo box wizard to find a record on the form, and look up the proper meaningful field on the main form.

Then add this to the form's On Current Event:

'==========
   cboYourLookUpComboBox = TransID
'==========

   This will synchronize the look up combo box with the main form's current record.

HTH.

mmcdonal