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

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


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
post Jan 3 2018, 05:41 PM

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



David Marten
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    19th July 2018 - 08:20 PM