Recent content by parkerk

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...

Aha! I need the VALUE. Thanks for pointing me in the right direction. I used this: sql = "INSERT INTO tblAnalyte (Analyte) VALUES (""" & Me.Contaminant & """)" works great. Thanks guys.

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...

OH. It definitely is. That was part of why I couldn't figure out the problem. Turns out, I had ALL Records locked. It worked perfectly as soon as I changed that. Thanks for the reply!

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...

Sam- Thanks for the tip. I used your suggestion on the combo box and it behaved perfectly. In order to add a new record, I added a text box to grab the name. So...I laid that textbox on top of the combo box and it LOOKS like it's just a combo box that you can type into. Hopefully, the...

OK. I have attached the relevant aspects of my database. Open frmChecklistSetup...My goal is to get that combo box, when a checklist is selected, to populate the subform with the selected checklist (as in an edit). When I want to add a new record, I think I will add a text box for the new...

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...

Anyone have ANY ideas, even to do it differently????

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...