How to edit (new / add record) using a combobow in a subformular
Posted on 2014-11-15
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
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