why is this form code not working

[Leanne]

Yes you are correct, when I hover over visitlist and invoicelist it shows ""
- could that have something to do with the fact that I am trying to clear the
data when saving. The list box (combobox) is on the form but it does pull
its list from a sheet. If I have to set focus or define a range can you tell
me how to do it please. I am a real beginer at this. Thanks

 

[JLGWhiz]

I am having a hard time visualizing your set up, but here is what it looks
like based on the code you posted.

You are trying to use code in a standard module to utilize values contained
in a control on a form. If this is true, and if the form is closed
(unloaded) when you try to use the control (listbox) value, it will not work
because the control no longer has a value. The form must be open at the time
you refer to the listbox value, or you must have stored the value to a place
that can be accessed after the form closes.

I would offer some sample code, but I don't want to confuse the issue even
more at this point. I'll let you mull this over and see if you can figure it
out on your own. If not, make a new posting with your code and start again.
Maybe somebody smarter than me can tell you how to work with what you have.

 

[Leanne]

Hi, I am having a hard time explaining what it is I am trying to do so it is
no wonder you are having trouble. I think it is something that should be
fairly easy but I just do not know enough about code or forms. I spent a
while on a post with Office_Novice who turned out to be less of a novice than
me but we still could not crack it so I doubt I will be able to do it on my
own.

Is there anyway you would be willing to let me send you the details so that
you could look at them better?