On Docmd.close a dialog box wants value for Forms![Find Skills]!listFi

[JimRich]

On Docmd.close 2 dialog boxes come up asking for values for Forms![Find Skills]!listFindSkill and Forms![Find Skills]!listFindSubCat.

These two criteria are used to fill the subcategory list box based on a value selected in the combo box. The other is used to fill the skills list box based on a value selected in the sub category list box.

The form works perfectly. All values are filled, user can make selection, print the data and the form is closed as instructed.

However, if the user selects the Close Form button, with or without selections made in the boxes, 2 dialog boxes asks for values for the two list boxes. I have tried makeing them null right before the docmd.Close, requearying before the close after making them null and several other things which did not work.

Useing debug and stepping thru the problem occurs when the Docmd.close is executed. I am about ready to execute it for real.

Thanks for helping again.

JimRich

 

[Sadukar]

I had the same problem. It happened when I was adding a record through my form but canceled before finishing. I too had a list box giving a similiar error.

I set the predetermined value of the list box to "0". You have to put the comas in too.

This solved my problem.

Hope this helps
Regards,
S