How to edit (new / add record) using a combobow in a subformular
Hi,
Here I am again with the same database you helped me to create almost 7 years ago.
Friends asked me to make a variation of that DB for a totally new project..
A DB for a multiprofessional medical consultation for orthopedic sepsis
ENtries are : consultation / patient identification/ patient clinical status
A Form to enter every consultation (once a week for each patient)
A sufform to enter the bacteria discovered at each consultation (One or sometimes several or none)
Everything works fine, but for some unknown reason, I lost the ability to add new bacterias..of remove one.. I can only select another one..with that subform
No VBA is used here.. just the properties of the tables/requiry and subformular
The subformular is_subMicrobiologie, which is connected to the table "Microbiologie" (
each record : Ref_RCP (consultation), ref_microbiologie, Ref_germe, date_detection, milieu)
Inside the subformular, I have un comboBox connected to a request -rqgerme_tries
this request is an ordered copy of the "germe" table which is the list of all known bacteria..(just a primary key Ref_Germe and the name of the bacteria), that request/table is related to the Microbiologie table by Ref_germe
When I add manually a new bacteria to a consultation directly in the microbiology table, I will find it in the subform when I check for that patient at that consulation (RCP).. So the connections seems fine.
The tables are editable and have both a primary index.
The microbiologie table has a double index : Ref_RCP (same as the main formular) and Ref_micorbiologie
last information
When I work directly with the subform, I am not more able to add/remove a record (of course, here the subform exhibits all the records of the microbiologie table, not only the selection by Réf_RCP key (mother and child of the subform)
I have tried a lot of modification of the properties without success. It is certainly very trivial but it is driving me crazzy..
I would greatly appreciate some help here
Best regards
Jacques
Here I am again with the same database you helped me to create almost 7 years ago.
Friends asked me to make a variation of that DB for a totally new project..
A DB for a multiprofessional medical consultation for orthopedic sepsis
ENtries are : consultation / patient identification/ patient clinical status
A Form to enter every consultation (once a week for each patient)
A sufform to enter the bacteria discovered at each consultation (One or sometimes several or none)
Everything works fine, but for some unknown reason, I lost the ability to add new bacterias..of remove one.. I can only select another one..with that subform
No VBA is used here.. just the properties of the tables/requiry and subformular
The subformular is_subMicrobiologie, which is connected to the table "Microbiologie" (
each record : Ref_RCP (consultation), ref_microbiologie, Ref_germe, date_detection, milieu)
Inside the subformular, I have un comboBox connected to a request -rqgerme_tries
this request is an ordered copy of the "germe" table which is the list of all known bacteria..(just a primary key Ref_Germe and the name of the bacteria), that request/table is related to the Microbiologie table by Ref_germe
When I add manually a new bacteria to a consultation directly in the microbiology table, I will find it in the subform when I check for that patient at that consulation (RCP).. So the connections seems fine.
The tables are editable and have both a primary index.
The microbiologie table has a double index : Ref_RCP (same as the main formular) and Ref_micorbiologie
last information
When I work directly with the subform, I am not more able to add/remove a record (of course, here the subform exhibits all the records of the microbiologie table, not only the selection by Réf_RCP key (mother and child of the subform)
I have tried a lot of modification of the properties without success. It is certainly very trivial but it is driving me crazzy..
I would greatly appreciate some help here
Best regards
Jacques
Can you attach a blank (no patients) copy of your database, so I can see for myself, precisely what is happening, and work out the solution.
AW
AW
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK
You have herre three forms
The "menu" form
The patient form
and the RCP form with its _submicrobiologie subform
If you want to add/remove a patient, you have to use the patient form..
One patient can be relate to several consultations (RCP) and several bacteria
when you are at the RCP form :
You can circulate between theRCP- records of that patient (Right and left arrows beside the title
You can create a new RCP record (the topLeft button with a star) related to that patient.
The patient identification is on the top of the form and is not supposed to change.
But everything else can be..if you have been alllowed to do it. This is done by using the flip/flop button on the top end right place upon the subform (an editing button)...
Some of the information boxes are related to the patient ID and some like " creatinine, Poids, hauteur" are related to the RCP table
I had to send you the an earlier version.. I thought everything related to my question was here.. But not really..Nevertheless, the problem is clearly seen here also..
The present version, (with the subform even compressed weights 96Mb.. I don't really know why..I didn't change a lot of things.
That DB is a clone of a DB 10 years old with now almost 20000 entries made by a team..and with worked exactky like this one. That earlier version is much more complicated with two subforms on the same RCP form. each of them allowing editing.. I just am unable to find what I have done to loose the editing property of the subform..
If you have a way to trasmit you a 96Mb file, I will do this
Your advice are nevertheless helpfull, I will look at my work with your eyes.. May be it will open mine
You have herre three forms
The "menu" form
The patient form
and the RCP form with its _submicrobiologie subform
If you want to add/remove a patient, you have to use the patient form..
One patient can be relate to several consultations (RCP) and several bacteria
when you are at the RCP form :
You can circulate between theRCP- records of that patient (Right and left arrows beside the title
You can create a new RCP record (the topLeft button with a star) related to that patient.
The patient identification is on the top of the form and is not supposed to change.
But everything else can be..if you have been alllowed to do it. This is done by using the flip/flop button on the top end right place upon the subform (an editing button)...
Some of the information boxes are related to the patient ID and some like " creatinine, Poids, hauteur" are related to the RCP table
I had to send you the an earlier version.. I thought everything related to my question was here.. But not really..Nevertheless, the problem is clearly seen here also..
The present version, (with the subform even compressed weights 96Mb.. I don't really know why..I didn't change a lot of things.
That DB is a clone of a DB 10 years old with now almost 20000 entries made by a team..and with worked exactky like this one. That earlier version is much more complicated with two subforms on the same RCP form. each of them allowing editing.. I just am unable to find what I have done to loose the editing property of the subform..
If you have a way to trasmit you a 96Mb file, I will do this
Your advice are nevertheless helpfull, I will look at my work with your eyes.. May be it will open mine
Hi Artur,
Look at this.. finally I checked all around and found the bug..
I have to allow add and remove by VBA.. Allow edit is not enough..
Now it works
So you helped
Any further advice would be helpfull.
I join here the working version.. Cleanup a little bit
RCP-Ortho-septique-v7-revue.mdb
Look at this.. finally I checked all around and found the bug..
I have to allow add and remove by VBA.. Allow edit is not enough..
Now it works
So you helped
Any further advice would be helpfull.
I join here the working version.. Cleanup a little bit
RCP-Ortho-septique-v7-revue.mdb
Glad to hear you found the solution by yourself. That means you have learned something that will serve you well in the future.
ASKER
When opened directly, without use of the parent form, the subform's ComboBox is perfectly editable. I can add/remode and modify
Of course, what is shown by the edited subform using this way is the complete table "microbiologie" connected to the subform, not the table filtered with the reference key of the parent form
This means that the filter through that reference make me loose the editing possibility