Search results

Thanks MarkK, I already have that going for choosing the color in my attached database in the first post. But what about the first name? I wanted the first name form field to be a text box, not a combo box. The Control Source I have for the text box is "=[tbFirstNames]![First_Name]", but...

I'm trying to wrap my head around how to best implement a form for this very simple database (attached). I have a database that keeps track of just first names and colors. Not every first name needs a color assigned to it, and vice versa. So, I have three tables: tbFirstnames First_ID (PK)...

Figured it out! I was able to base the subform (subfmTaskNotes) off a new query: quTaskNotes Field:jcttbTaskNotes.* Table: jcttbTaskNotes Field: Details Table: tbNotes Field: Task Table: tbTasks Sort: Ascending Then, in the subform, I set the control source for the "Notes" combobox...

In my database (attached), I need to be able to store multiple notes for tasks performed in various cities -- each note has a small description (more on that at the bottom of this post). For the "San Antonio, TX" task, notes "Heartbleed" and "BAT Scan" apply. From what I understand, this is...

Thanks, Fran. Right now I'm not trying to add a record, I'm just trying to modify records by changing the State for any City using the query. I made the StateID and CityID fields Primary Keys in their respective tables, but I'm still unable to type anything in the State field in the query...

I figured I could keep it simple like that, but from all the articles I've read about one-to-many relationships, the forms created for those relationships involve a main form and a subform based on a parent and child table, respectively. So I figured that was a best practice or general rule of...

Well, now that I think about it, I dont know where I read that. I think it was some forum posts either on this forum or on other Access forums. I got that impression from somewhere so I've always based my forms off queries. I understand that, but for the sake of allowing easy administration...

Ahh! I borked up my post, thanks for pointing out the way my tables were structured! The way you posted is the way that I actually have it -- tbCities has FK to tbStates, and tbStates has a FK to tbCountries. I just brainfarted when posting this, I fixed my OP. In short, what we have is a...

My goal is to create a form that allows me easily edit what State each City is assigned to, and edit what Country each State is assigned to. I have 3 tables: tbCities CityID (Primary Key) StateID (Foreign Key from tbStates) City tbStates StateID (Primary Key) CountryID (Foreign Key from...