What I want to happen is, when the fields in the New Record subform is filled, two other subforms below it, both in datasheet view, will be automatically updated. The two other subforms are: Current Medications subform and Past Medications subform.
In other words, if the checkbox: Current, found in the New Record subform is checked; the data/entries about that particular medication should automatically go to the Current Medications subform. Past Medications should also behave similarly.
Here's an outline:
Patients Form
Page 2: New Record subform
Current Medications subform
Past Medications subform
Details/Links/Relationships:
Patients Form (based on Patients Table)
New Record subform (based on Medications Query)
Current Medications subform (based on Current Medications Query)
Past Medications subform (based on Past Medications Query)
Current Medications Query (based on Medications Query; only shows entries that have checked Current Field; in other words, shows entries with Current Field = Yes
Past Medications Query (based on Medications Query; shows entries with Past Field = Yes)
Medications Query (based on Medications Table; has a calculated field based on two fields from Medications table)
I am using Access 2010.
I have very little background on Access so please give detailed answers.
Thanks!