Recent content by bigalpha

Yeah, that did the trick!

Thanks so much - I had part of that down but wouldn't have gotten the rest of the more intricate parts of that code. Your time is much appreciated!

Thanks, that's definitely something worth keeping for future use. I do like the idea of having the dual boxes for end user use because I think it's easier to manipulate the data. In my case, though, that won't work as easily since I'm recording new records in a junction table, right? I...

I think I'm missing a step somewhere. I have my listbox rowsource set to show all inventory. I set up a query that shows the inventory assigned to each Show (this is filtered based on combo box selection.) In your notes in the code, you say to deselect the selected item in listbox; nothing...

Sorry for the delayed reply. Yes, all my tables have their own unique ID's so looks like option 1 is the path forward. Yes the bound column of the combo box is the Shows ID. Not extremely familiar with this set up so I have some extra research to do. Thanks for your knowledge. If I can...

I have a list box that allows multiple selections [Inventory]. I also have a combo box that has multiple selections [Shows]. Right now, user selects from list box and from a combo box and clicks a button. On button click, the items from the list box are associated with the PK from the combo...

Thanks again for your help!

The reason I used the description is because the entry is a text box; so the code would look at what you typed in it. Because this data is getting stored in the lookup table(s), I didn't think I'd need the ID's.

Uhhhh, sorry. I was continuing my previous thought on adding data. Sorry, I should have specified. I created a separate form to do the data entry in because that's more intuitive for the end user, IMO. So this block of code is only for adding data to the tblCollection, tblDesignName and...

I have 3 unbound text boxes that the data will get entered into. The code will execute on a button click. Ah, figured out part of this. While I was working with getting the code to work, I inadvertently mixed up references to the text boxes. I fixed that and now the code works as-is. Can...

Crap. I updated it to be correct. What I want: 1. If there's text in the textbox and it does not match an existing record, then add the value from the textbox. 2. If there's no value in the text box, do nothing (add no values). [I haven't implemented this into the code] 3. If there is...

Well, I'm back. I spent all day yesterday trying to get this to work with different methods to no avail. What I want: 1. If there's text in the textbox and it does not match an existing record, then add the value from the textbox. 2. If there's no value in the text box, do nothing (add no...

Right, but I figure that having the entry a little more blatant and intuitive would be good in this case. edit: not that I know how to get it to enter a new line in the lookup table then add the corresponding PK to the inventory table.

I definitely feel like it'd be easier for me to code a small entry form that opens up that allows a new inventory entry.

Preferably yes, though I'm not adverse to having it open a 'new entry' form for this purpose.