troubleshooting Question

How to edit (new / add record) using a combobow in a subformular

Avatar of Jacques Weissenburger
Jacques WeissenburgerFlag for France asked on
Microsoft Access
7 Comments1 Solution256 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Arthur_Wood

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros