Please see screenshot attached.
Hello everyone.
I got great help here getting my data structure and tables in order, and have built some forms succesfully, but ran in to a bit of a problem.
Before i explain i would like to thank all who helped me to get my data in order, especially Minty!
Here is what i am looking to accomplish.
The first form i open is a form with table look with list of patients from personal_clinical_info....
And on the top or bottom in header and footer, i want to have buttons to open a form that i select in that table in another full personal and clinical detail form.
I created a form, i created a query with maybe 5 items from the table, when i created a form i dragged this query in to that form and all was fun and good, until i wanted to make a first command button that opens a record i select on in that query i dropped on the form. It says you have chosen forms that can not be linked. The DB is almost ready, and i can't get past this issue. As design with displaying some info from table in order to open it with a command button is a best solution. I simply can't get as far as tie them together.
Do you understand what i am looking for?
Maybe main form is worth having in a subform design?
Please ask if i didn not explain well what i am trying to accomplish.
Hello everyone.
I got great help here getting my data structure and tables in order, and have built some forms succesfully, but ran in to a bit of a problem.
Before i explain i would like to thank all who helped me to get my data in order, especially Minty!
Here is what i am looking to accomplish.
The first form i open is a form with table look with list of patients from personal_clinical_info....
And on the top or bottom in header and footer, i want to have buttons to open a form that i select in that table in another full personal and clinical detail form.
I created a form, i created a query with maybe 5 items from the table, when i created a form i dragged this query in to that form and all was fun and good, until i wanted to make a first command button that opens a record i select on in that query i dropped on the form. It says you have chosen forms that can not be linked. The DB is almost ready, and i can't get past this issue. As design with displaying some info from table in order to open it with a command button is a best solution. I simply can't get as far as tie them together.
Do you understand what i am looking for?
Maybe main form is worth having in a subform design?
Please ask if i didn not explain well what i am trying to accomplish.
