Completing Table updates

[GraeagleBill]

Form A has as its RecordSource a query based on the fields of Table A.

Form B has as its RecordSource a query based on the fields of Table B. (The two queries are exclusive of each other. I.e., NOT union queries)



Form B has in its code sheet Dlookups of fields contained in Table B.

Form A has amongst its command buttons a command button to open Form B.

Form A has in all likeliness updated text-boxes bound to fields in its RecordSource, notably the very fields Form B will execute DLookups upon.

Finally, the question is what needs to be executed in Form A prior to launching Form B that will force completion of any updating to fields in Form A's RecordSource?

Thanks,
Bill

[pbaldy]

Sounds like:

If Me.Dirty Then Me.Dirty = False

[GraeagleBill]

Paul,
That seems to have done the job.
While the original post is accurate, as far as it goes, I find a bit of a ripple with regards to how and when the table record is referenced. As described, Form B is the form opened from Form A. However, Form B has two sub-forms, one of which is where the error seemed to originate, I'll call that sub-form "B/S". "B/S" has 6 text-boxes whose display "Fore Colors" are determined with "Conditional Formatting". It is in the "Conditional Formatting" that a function is employed in the code sheet of sub-form "B/S" to test the status of table fields that are a part of the "ControlSource" of Form A. I added your suggestion "If Me.Dirty Then Me.Dirty = False" just before the DoCmd.Openform of Form B. I tested the app several times making changes to the fields discussed here immediately before hitting the command button that launches Form B.

As usual, you're help is greatly appreciated.
Bill