Subform's Form_Current is Triggered When Value in Parent Form is Changed

R

Robert Robichaud

I originally posted this at microsoft.public.access.forms newsgroup but had
little success. I'm hoping there's someone on this newsgroup that may be
able to help me on this.

I have a main form with 2 subforms in Access 2000 .adp.

Each subform is linked to the parent via LinkChildFields and
LinkMasterFields (a field in the main record called OrderID). Each time I
set a value in the main form (e.g. Me!ShipDate=Now() ), the first subform's
Form_Current is triggered followed by the second's subform's Form_Current
then control returns back to the next statement in the main form (stepped
through this in Debug many times).

The Reference library is as follows:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object library
Microsoft ActiveX data Objects 2.7 Library
Microsoft ActiveX Data Objects Recordset 2.8 Library


Any suggestions or ideas on how to address or debug this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform's Form_Current is Triggered When Value in Parent Form is Changed 9
Problems starting Word from Excel VBA 3
Calling a method in a subform's parent form? 1
Form_Current, Form_Load error out in a SPlitForm in an ADP file (?!) 0
output filter string to text box on form 3
HTML Access Form Failing 0
File dialog in Access 2003 doesn't show. 2
Access 2007 Conversion Issue 5

Top