Yes, that worked! Now I need to implement a way to dynamically choose the store groups via a combobox that references my StoreGroups table. I;m sure I'll need more help
Thanks a million for all of your help so far. I'm learning a lot.
Yes, that worked! Now I need to implement a way to dynamically choose the store groups via a combobox that references my StoreGroups table. I;m sure I'll need more help
Thanks a million for all of your help so far. I'm learning a lot.
I need a copy of the DB to help farther.
If you don't want to post it here for the world to see, Private Message me and I'll give you my email address.
I may take you up on that, but I want to try to figure it out a bit first. I was testing the code that I have so far and I found that the date is saving incorrectly. The date being saved into the table is 12/30/1899, regardless of what I enter into the date picker. When I look in the immediate window the date being read in the code is correct, so it is changing upon saving it. I am thinking it's because sSQL is a string?
I may take you up on that, but I want to try to figure it out a bit first. I was testing the code that I have so far and I found a couple of issues that I fixed on my own:
1) Some fields could be null, so I added nz(varient, "Null") to them
2) The PriceDate wasn't saving correctly into the table, since it was a string. I changed it to "#" & Me.PriceDate & "#"
I'll play with the combo box idea and let you know if (when) I need more help. Thanks a million!