Hi,

Here's the skinny:

I have a main form what holds a subform called "Caller Record" ([forms]![frmMain]![sbfrmCallerRecord]). I have a little code that checks when a person inputs a new "caller". If it finds a record with the same phone number the user is entering, it kicks out form ([frmPossibleMatch]} with a listbox (lstPossibleMatch) that allows the user to select the record they want work with (or ideally that's what it should do).

However, jumping from this form (frmPossibleMatch) to the appropriate record in the sbfrmCallerRecord subform is killing me. I have tried this in a variety of ways, but failed.

here's my latest attempt (this is code from the frmPossibleMatch):

    [Forms]![frmMain]![sbfrmCallerRecord].SetFocus
    [Forms]![frmMain]![sbfrmCallerRecord].Requery

    With [Forms]![frmMain]![sbfrmCallerRecord]
        DoCmd.GoToRecord , , , Me.lstPossibleMatch.Column(0)
    End With

If anyone has a suggestion, please help!

KT

hi there

   well i am a newbie in VBA but still lets see ,


    If ( a-1 ) Then
       DoCmd.OpenForm "Form2"
    End If


a-1 = your condition - If it finds a record with the same phone number the user is entering - probably you should write a module or pragraph some sort of which should query from database and find possible match and if match is there then pop up the form2 by
DoCmd.OpenForm "Form2"

may be i m totally wrong ..then i m sorry i m totally new to this

Thanks and Regards
Lawson, COBOL

Thanks for taking a stab at it Lawson,

Your method works well for opening a form under certain conditions (i.e., a-1). Unfortunately, I'm trying to get from one open form (frmPossibleMatch), where the user has selected which record s/he wants to open, to that specific record in a separate form's subform (frmMain!sbrfmCallerRecord).

To clarify a little:

Basically, if I type in 777-888-9999 as the phone number, I get a little list box showing me other calls that were made from this number. Let's say:

Howie Smith 777-888-9999
Bert Smith 777-888-9999

The idea would be, since the user knows s/he is taking to Bert, s/he could click on Bert's name and be taken to his record in the DB.

I know how to work this if it's a form and not a subform, but I keep getting a "cannot go to specified record" with this subform in play.

Thanks,
KT