Search results

It's working now. Thanks a lot! I put the code in the After_Update event of another control on the form that is required. The Before_Update event of the FORM wasn't triggering. It's probably just the way that I have the form setup. Thanks for your help. -Liz

I'm not sure why I'm having such a hard time with this because I've done it before with a combo box, but when I use the following code with a text box, I get the "Can't assign value to this object." If the user doesn't enter a pend date, I want it to assign the current date + 7 days to the...

Thanks a lot! I was able to figure out a work around between both of you.

Try this: Private Sub cboPendDate_Exit(Cancel As Integer) cboComboBoxNameGoesHere.Text = "" End Sub This will clear it out when you leave the control - not sure if that's what you want or not....

Is it possible to have the current day's system date (in the Short Date format) as one of the values in my combo box? I've played around with =Now() and things like that but it literally displays =Now() as the value and I want it to display 12/13/2000 (for example). I'm thinking I probably...

I am building an issue log database. I have a combo box on a form that lists names of people that could be an OWNER for a particular issue. When someone is chosen from the combobox (i.e. when they trigger the CHANGE event), I need to insert a record into a table called Person_Issue_Involvement...