[b][/b]Delete code problem! PLEEEEEEEASE HELP!

sal · October 10th, 2003, 03:27 PM

How many times is the Do loop being executed?

Sal

sherr8 · October 14th, 2003, 03:24 PM

Quote:

quote:Originally posted by sal
How many times is the Do loop being executed?

Sal

Only once I checked all the code and it's fine it might be the form's properties. I cannot think of anything else

slypunk

sal · October 15th, 2003, 09:40 AM

On this code
'Get contract Number
Form_frmEnterContNo.lstContNo.SetFocus
strContNo = Form_frmEnterContNo.lstContNo.ItemData(Form_frmEnt erContNo.lstContNo.ListIndex) & "'"

Do not use .ListIndex The index is the zero based value for an array. Use .value and make sure that you are setting the value of the combo box (or list box) to the contract number.
What is the contract numberbeing selected? which contrct number is being deleted?

Sal

sherr8 · October 15th, 2003, 12:36 PM

Quote:

quote:Originally posted by sal
On this code
'Get contract Number
Form_frmEnterContNo.lstContNo.SetFocus
strContNo = Form_frmEnterContNo.lstContNo.ItemData(Form_frmEnt erContNo.lstContNo.ListIndex) & "'"

Do not use .ListIndex The index is the zero based value for an array. Use .value and make sure that you are setting the value of the combo box (or list box) to the contract number.
What is the contract numberbeing selected? which contrct number is being deleted?

The user has the option of adding contract numbers and deleting contract numbers. He/she may wish to delete any contract number they want by selecting it from the listbox and then hitting delete.
I switched the code from .ListIndex to .Value like you said but it gives me an error of invalid use of null. This is an example of a contract number (e.g. S-746; W-846; ER-47620....) Thank you

Sal

slypunk

sal · October 15th, 2003, 01:20 PM

a value must be selected in the list box for this to run.

Sal

sherr8 · October 20th, 2003, 09:42 AM

Quote:

quote:Originally posted by sal
a value must be selected in the list box for this to run.

Sal

Thank you for your help I'll let you know how it goes. :D

slypunk

sherr8 · October 20th, 2003, 10:37 AM

YES! I finally figured out what the problem was. In the listbox properties the Control Source was supposed to be left blank I accidently chose the ContractNo field that is why is was deleting the first record. Thank you very much for your help! :D

slypunk

sal · October 20th, 2003, 10:51 AM

Great!!!!!!

I am glad it worked, even if I was not much help.

Some times we forget the simplest things. Take care.

Sal