Search results

OK. I had to build a database before that did something similar to what I'm trying to accomplish. I am trying to get a subform to populate based on a combo box selection...thing is, it needs to append records to a table to work. Here is the link to my db...

Alright. I'm trying to do something very simple here. Apparently, I don't know enough VBA to get it done. I have a form, frmContaminant. For each new contaminant, I want it to add a record to a different table, tblAnalyte. These tables are set up similarly, as so: tblContaminant ContaminantID...

Hello. I am having a tough time filtering my form. There are two forms in question here: frmMenuDataEdit and frmFacilityEdit. I am trying to open frmFacilityEdit (with data) to a record selected on frmMenuDataEdit. On frmMenuDataEdit, I have a combo box based on a query that pulls three fields...

I have a form where a user defines a checklist. There is a ChecklistName combo box where the names of all previously defined checklists, and where you would type the name of the new one (LimitToList = No). I am trying to get the subform to Update with the selection of each checklist in that...

OK... I have been working on this observational database for awhile now, and have run into another hurdle. I am trying to get a 'checklist' to show up. This is how I've set things up: There are tblchecklistname, tblchecklist, and tblchecklistdetail table. The tblchecklistname contains 2...

So I am wrestling with an idea and can't figure out how to set up my relationships to get it to work. I am little dyslexic and find myself rethinking the same stuff over and over again (and not getting anywhere). Attached is my relationships diagram. Every table I have is included. What I am...