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    
post Jan 3 2018, 01:27 PM

Posts: 592
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
post Jan 3 2018, 01:29 PM

Access Wiki and Forums Moderator
Posts: 73,501
Joined: 19-June 07
From: SunnySandyEggo


Have you tried using the Form's Current event?
Go to the top of the page
post Jan 3 2018, 05:41 PM

UtterAccess VIP
Posts: 10,462
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:

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.


Attached File(s)
Attached File  2subforms.zip ( 44.28K )Number of downloads: 8
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    21st October 2018 - 10:12 AM