Bevos
asked on
Access 2007: Command Box VBA code to pass on contents of one field in form1 to another field in form2
Hello, I am attaching the database to this question, but perhaps it won't be needed for some of the experts here.
Basically, I have a form (frmPtCharacteristics) with many forms which describe characteristics of it (i.e. groups present in the form, disease information etc...). I've attached an image of the database relationships here as well. I have tried to make the form normal and relate each table to the necessary keys.
On the main form there are several boxes (Groups, Race, Ages, Disease, Site/Category) displayed horizontally. Currently, when the user clicks one of this the current form will close and it will open the selected form. However, I want to pass on the [Call Number] (listed as 'record number' in label).
So for example, someone clicks the Groups command button when on record number 0001 in the frmPtCharacteristics. The frmGroup should now ONLY let the user enter information pertaining to record number 0001. Similarly, if someone selects the Race button they should only be able to enter information about groups belonging to the parent call number ([tblPtCharacteristics.[Ca ll Number] is related to tblGroup.[Call Number] and tblGroup.[GroupNumber] is related to tblRaceDesc.[Group Number])
How would I go about setting these controls to the command button in VBA?
EE-example-relationships.bmp
Basically, I have a form (frmPtCharacteristics) with many forms which describe characteristics of it (i.e. groups present in the form, disease information etc...). I've attached an image of the database relationships here as well. I have tried to make the form normal and relate each table to the necessary keys.
On the main form there are several boxes (Groups, Race, Ages, Disease, Site/Category) displayed horizontally. Currently, when the user clicks one of this the current form will close and it will open the selected form. However, I want to pass on the [Call Number] (listed as 'record number' in label).
So for example, someone clicks the Groups command button when on record number 0001 in the frmPtCharacteristics. The frmGroup should now ONLY let the user enter information pertaining to record number 0001. Similarly, if someone selects the Race button they should only be able to enter information about groups belonging to the parent call number ([tblPtCharacteristics.[Ca
How would I go about setting these controls to the command button in VBA?
EE-example-relationships.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.