Search results

I am an Access Beginner, I have a medications database based on 3 tables...tblPatients, tblPatientMedications and tblMedications. I can query for patients using a single medication. I need to query for patients who use: 1. both MedA AND MedB 2. both MedA AND MedB but NOT MedC 3.MedA OR MedB but...

I have simple form (2 fields and a combobox) bound to a single table. The form needs to open with the Patient_ID taken from the current main form and the ProtPat_ID at autonumber. It works now with one hiccup, the form opens with ProtPat_ID at autonumber but with an empty Patient_ID field. If I...

Subform Autonumber doesn’t update many side table I’ve got an Access form (ProtocolPatients) containing a continous subform based on a 3 table many to many relationship query. With a comboBox in the main form, I select a protocol number and the subform populates with the patients for that...

I'm trying to figure out why when I create a new record in my main form the autonumber doesn't update in the subform. I created a quickie test DB (dbBWorks) because I couldn't believe it wasn't working, and sure enuf it worked and updates as expected but I would really like to know why my...

I have a tab control with 2 tabs. I start a new record and the autonumber gives me a new number. I switch to tab2 only "autonumber" shows where the new ID should be in both the header and subform. The kicker is with existing data everything works as it should. Thanks

I have a medical database setup with a form including a tab control with two tabs…patients and medications/conditions. The patients tab holds a single form. The medications/conditions tab holds two individual continuous subforms by query for medications and conditions. This is working perfectly...