UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Continuous Form - Run Macro If Move To Prev/next Record, Access 2010    
 
   
Brepea
post Jan 3 2018, 01:27 PM
Post#1



Posts: 564
Joined: 11-January 09
From: UK


Hi All

I'm a little stumped here. I have a continuous subform on unbound form; How do i run a macro or do something when the user moves from one record to another (whether prev or next)? When they move i need another subform on same main form to requery. I've tried linking master/child and manually entering the child/master and still doesn't 'link it' - hence i'm trying to do the requery once user moves to next record (on the query of subform that i want requeried - there is a criteria 'effectively' linking it.

Go to the top of the page
 
theDBguy
post Jan 3 2018, 01:29 PM
Post#2


Access Wiki and Forums Moderator
Posts: 72,745
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Have you tried using the Form's Current event?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Jan 3 2018, 05:41 PM
Post#3


UtterAccess VIP
Posts: 10,140
Joined: 6-December 03
From: Telegraph Hill


You don't need to use any code.

Place a hidden textbox on your unbound form. As its ControlSource use:
=[YourFirstSubFormControlName].[Form].[ID]

Then use that in your Master link of the second formm and set the Child link to the respective field in the second subform.

See example attached.

hth,

d
Attached File(s)
Attached File  2subforms.zip ( 44.28K )Number of downloads: 8
 

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th July 2018 - 05:02 AM