Search results for query: *

I never got the problem resolved, I just simply made the form close and reopen to clear all fields.

I've been trying Me.ListBoxName = "" with no luck. I just want to clear any selections the user has made and am pulling my hair out right now!

I'm having trouble clearing the selections in a multiselect box. Setting the control null does nothing and I've had no luck figuring out some code on my own. Anyone able to give me a hand?

I've got a form that generates multiple insert sql statements to go along with a multi select box. I've got the code working right and outputing correct sql into a variable. Here is a sample of the output, sorry if it's a little messy: INSERT INTO tb_test Values...

Thanks for the help, however, I still am unable to get the default value to stay when the form is closed. I have tried adding a DoCmd.Save, however the new default value does not stay after the form is closed. Once the form is opened again the original default value comes back.

Here is the situation, I have a main form that loads that has a combo box on it that is locked and not enabled. I've made another form that will allow the combo box to either be unlocked and enabled, or have the default value changed to a value on the form. I've written some code but it doesn't...

I've been looking for a way to disable to shift key at startup but have been unable to find anything that works. The database in question is in Access 2k. I've looked around on these boards and found a few possible solutions, however none of them seem to work for me. Can anyone give me a hand in...