Opening Form and Moving to Selected Record

[dantebothermy]

Hi friends,

I want a script that will move a form to a chosen record.

Here's what I'm trying:

I get the parameter from la different form using Docmd,openform using openargs

I've been trying docmd.gotocontrol followed by docmd.findrecord, but I keep getting complier errors. Here's my code:

   If Len(Nz(Me.OpenArgs, "")) > 0 Then
    DoCmd.GoToControl "MemNo"
    DoCmd.FindRecord OpenArgs, , , , , acCurrent
End If
 

It crashes on the first DoCmd command.

Please help.


Dante

(note that 'DoCmd.OpenForm stDocName, , , stLinkCriteria will not work for this application. That limits the records in the form to those meeting the criteria; I need my user to be able to access other records. )

[missinglinq]

Where is your current code placed?

Linq ;0)>

[dantebothermy]

Hi Linq,

This code is in the OnLoad of the destination form.

Here's the whole thing:

Private Sub Form_Load()
If Len(Nz(Me.OpenArgs, "")) > 0 Then
DoCmd.GoToControl "MemNo"
DoCmd.FindRecord OpenArgs, , , , , acCurrent
End If
End Sub


Thanks Linq.

[dantebothermy]

Call off the dogs!

Now it works, and I know why.

Thanks anyway Linq and all others who''ve tried


Dante

[missinglinq]

Glad you got it working! Forum etiquette, here and elsewhere, dictates when the original poster solves the problem "off-line" that they post the solution. That way, others with similar problems, who come searching and find the thread, can also be helped.

Linq ;0)>