Setting active record on navigation form (1 Viewer)

LadyMarmalade

Registered User.
Local time
Today, 07:10
Joined
Sep 23, 2014
Messages
26
Hi,

I am struggling in general to deal with navigation forms at all.

How could I remotely set the active record of a navigation form via VBA?

Thanks,

Lady marmalade
 

Cronk

Registered User.
Local time
Today, 18:10
Joined
Jul 4, 2013
Messages
2,770
A generic question elicits a generic response. Something like

forms!yourForm.recordsetclone.findfirst "YourFieldID=" & yourLookupValue
forms!yourForm.bookmark = forms!yourForm.recordsetclone.bookmark
 

LadyMarmalade

Registered User.
Local time
Today, 07:10
Joined
Sep 23, 2014
Messages
26
A generic question elicits a generic response. Something like

forms!yourForm.recordsetclone.findfirst "YourFieldID=" & yourLookupValue
forms!yourForm.bookmark = forms!yourForm.recordsetclone.bookmark

Yes! I'm so sorry - I figured out how to do it soon afterwards, but lost internets and couldn't update this thread.

Thank you though!
 

Abeiis

New member
Local time
Today, 00:10
Joined
Feb 28, 2017
Messages
4
Hi ALL,
I have a similar issue but different (talk about confusion :) )
My issue is getting from one sub Form in Navigation Control (by clicking on a [Next] button, to a combo-Box in another tab sub-Form. MS does not make it intuitive to do nor do they give a good way to do it... I appreciate any help in that direction. If only I can understand the logic behind movement (back and forth) between Navigation Tabs that would help greatly, and some code wouldn't hurt ;-).
 

Users who are viewing this thread

Top Bottom