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:

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. )

Dec 16 '08 #1

missinglinq

Where is your current code placed?

Linq ;0)>

Dec 16 '08 #2

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.

Dec 17 '08 #3

dantebothermy

Call off the dogs!

Now it works, and I know why.

Thanks anyway Linq and all others who''ve tried


Dante

Dec 17 '08 #4

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)>

Dec 17 '08 #5