Need to update a table onExit from form field. Info fol:
Table1:
Master. lists all aspects of plat entry & mgmnt.
Primary field is PlatRef
Table2:
Search DB. Contains all possible addresses associated
with plat.
Primary Field is Auto#
Relationship:
1(tbl1)-many(tbl2) using PlatRef.
Query:
Filters for non-processed plats from tbl1 and includes
tbl2.
On plat completion, user enters date in DateComplete field. OnExit VB code should make initial entry for primary address from existing fields on form to tbl2. All perform swimmingly except for populating tbl2 PlatRef. VB Editor's 'List Properties/Methods' includes table name for PlatRef [unlike other fields for same table] and will not activate drop-down menu on dot placemenet to followup with 'value'.
Attempted a not-visible txtbox to name tbl2 PlatRef in properties. Error required saving form first which was solved using 'DoCmd.Save acForm'. Still received errored requiring object.
Query makes all fields from both tables visible.
Bottom line, I can't get this field to be recognized as an object... and work. Really tried to find something in our FAQs and Search without success.
Table1:
Master. lists all aspects of plat entry & mgmnt.
Primary field is PlatRef
Table2:
Search DB. Contains all possible addresses associated
with plat.
Primary Field is Auto#
Relationship:
1(tbl1)-many(tbl2) using PlatRef.
Query:
Filters for non-processed plats from tbl1 and includes
tbl2.
On plat completion, user enters date in DateComplete field. OnExit VB code should make initial entry for primary address from existing fields on form to tbl2. All perform swimmingly except for populating tbl2 PlatRef. VB Editor's 'List Properties/Methods' includes table name for PlatRef [unlike other fields for same table] and will not activate drop-down menu on dot placemenet to followup with 'value'.
Attempted a not-visible txtbox to name tbl2 PlatRef in properties. Error required saving form first which was solved using 'DoCmd.Save acForm'. Still received errored requiring object.
Query makes all fields from both tables visible.
Bottom line, I can't get this field to be recognized as an object... and work. Really tried to find something in our FAQs and Search without success.