Search results

Attached is what I have for this form along with some test data. I'm sure it's something small that I've missed somewhere. Thank you for taking a look!

It's all on one form. Not sure if this matters but the Regulation Set is a combo box that has a record source in a different table. I had some other code on the form on the On Close and On Unload events that I just cleared out. Now I can enter data on the form and the save button works. But...

I have a data entry form with a Save button that runs a SQL insert statement. If I enter data in the form and use the record navigation buttons, the record saves without any issues but when I click the button, I get the warning that I am about to append a record, which is fine, and then I get...

Thanks for the help and suggestions; you guys are helping me learn a lot! I think I'll try the MVF route again. I really like the look and usability of a combo box in this instance and if it works, it's a very quick process. It worked for data entry on a small test that I did; hopefully I...

Thanks for the quick responses! DBGuy, that's an interesting post and a neat way to make the subform look like a multi-select combo box. If I understood the intent correctly, the poster was not opposed to using MVF, and his workaround was for pre-A2007 (I'm using 2016). I've seen mixed...

I have a form that I want to use a multi-select combo box with a junction table as its control source. Let's say I have a table to store people and a table to store hobbies, and a junction table with FK_people and FK_hobby. I want to be able to enter a record for a person and select zero to...

That worked! I have a requery on the After Update event for Kingdom but incorrectly thought it would fire in this case. Now it is working exactly how I wanted and I learned something new. Thank you for your help Vlad! Much appreciated!

I was wrong about one thing - there is consistency in the Species values that are returned: they are all for the same Kingdom value. I thought they were different but they are not. Still digging...

Hi Vlad - Thanks for the reply! I tried your approach but unfortunately couldn't get it to work. I made a couple of small changes and now I don't get any errors but I also don't have consistent results. Here's what I ended up with: Me.cboSpecies=dlookup("[ID]","Species","ID=" & Me.SpeciesID)...

Hello, I have a problem with combo boxes that I am hoping someone can help point me in the right direction. My Access and VBA knowledge is limited but I am very familiar with the concepts of building applications on databases (mostly Oracle). To keep it simple, I’ll use an analogy of an...