Hello, I have been working on a database with some of the experts here for some time, but I still can't quite get things to work. My hope is that I can explain what I want to occur and then maybe someone can point me in the right direction.
When the form opens, the user will begin entering characteristics (frmPtCharacteristics) about an article on cancer with a unique [Call Number] field. After this, the user will describe the groups in the article (for example the control and experimental groups which each have their own composition of characteristic diseases/ages/race). Next they will give the treatment characteristics for the study attempting to cure the patient group of cancer (for example treatment gets drug A control gets drug B). And lastly they will enter the outcome information (for example after treatment Group A had 10% survival at 5 years and group B had 0% survival at 5 years, or Group A had an increased quality of life etc...). The end result of this will hopefully be a series of filters/list boxes where users can select any pertinent fields from the database and export a landscape table to MS Word (for example saying you only wanted to look at Group A persons with Cancer type X in stage 4 and you want all the survival outcomes). I have attached an image of the proposed order that users will navigate the forms and also a current image of the realtionshps in the database. I have been trying very hard to get this to work, but before this time I have only made simple databases with two or three tables linked on a key with no sense of normalization.
Basically, I'm having a lot of trouble getting the database's forms to work how I envisioned. When a person begins using the database for the first time some of the fields will already be populated in tblPtCharacteristics (Author, Year, and Call Number). The user will select from the combo box at the top of frmPtCharacteristics the article they want to review (ex. [Call Number] = 0003). When a user moves from this first form (frmPtCharacteristics) to frmGroup I want to copy the active [call number] to tblGroup then they can enter however many groups they want all while keeping the same reference to the initial call number (i.e. I enter three groups each with call number 0003) and this assignment doesn't change unless the user uses the drop down box to search for another call number. Each form has a subform where I want to display the groups for that call number (i.e. only show the three groups for ID 0003 and none for 0002) so that the user can be aware of what has been entered thus far. Currently the forms are severely bothed and do not function like this. I get frequent calls to 'Enter Parameter Values' and I feel like I have something basic not set up correctly. Also, in some fields I do not think the forms are related correctly, or I have misspecified row source because I do not get a selection choice where there should be one (for example if I create several groups then I can not select them from frmAge frmRace etc... where I should be able to enter information about those groups)
If anyone can help with this I would appreciate it so, so much. I'd give you a million points if I could. I've been stuck on this for a while so any comment is helpful. This database is to make some electronic work easier for non-profit researchers of cancer so your contributions would be for a good cause.
Thank you again,