I am creating a DB to handle/record a process that has basic information
(Table1), I have a data entry form (Form1) for this table/information that
includes a “ID1” field (stored "ID1" is TEXT and generated by VBA code
“beforeinsert” and is unique/key). I would like to have command buttons (at
least 3) on this form that will when selected (clicked):
1). Mark a corresponding Yes/No box in “Table1” (“ReqAction1a”) to “True” for
later querying (not visible on form).
2). Then copy the value in “ID1” from “Form1” (for relating tables, one to
many and user reference).
3). Open “Form2” (data entry form for Table2) and paste/insert the copied
value to textbox “ID1” on “Form2”. This will be the value for table
relationship(s). “ID2” will be code generated for unique record ID in Table2.
4). Close “Form2”.
NOTE 1: Data properties in the form textboxs for “ID1” and “ID2” are set to
Enabled= No and Locked= Yes, this is to prevent editing in the form(s).
NOTE 2: Table and field names are not actual names (avoid using numbers in
table/field names).
NOTE 3: Have been using a “Flat File” for managing this data but have
completely out-grown it’s capability/practicality, so this will be my first
true relational DB.
NOTE 4: I am spanking new to VBA code writing (was using Macros but would
like to avoid them in this DB).
Any help/guidance would be greatly appreciated.

DCC