Struggling with invalid property code

[jancliff]

I have a user form that the user can choose from 4 drop down boxes. They will be set so the user cannot leave them blank. There is a button on the form that then adds the data to a spreadsheet called Core Data.

Please Login or Register  to view this content.

I know its something to do with the clearing of the data to give a blank form. I'm sure I'm missing something staring at me in the face. Would anyone be able to point me in the right direction as I am a little new to this.


Ultimately I wanted to have a button on a spreadsheet that calls the form, the user enters the data presses a "Add" button that writes the data back to the worksheet CoreData and then gives the user a blank form to try another line if they wished.


Any help is greatly appreciated.

Many thanks

[romperstomper]

You haven't said where the error occurs. My crystal ball is a little fuzzy today but suggests that you probably have another event (not shown) that is causing the issue.

[Zer0Cool]

I have a user form that the user can choose from 4 drop down boxes. They will be set so the user cannot leave them blank.

I know its something to do with the clearing of the data to give a blank form.

Without all the code and/or a sample its hard to give you a specific fix but I agree that this is the culprit.

If you are really enforcing the fields/drop-downs to have an entry, the same rules apply to you, you cant clear them then unless you account for allowing this.

[jancliff]

Thank you so much for responding. I am very grateful.

I get the error when I press the cmdbuttonAdd button, which has the code attached to as above. If I take out the code from clear the data ,

Please Login or Register  to view this content.

Without it, it doesn't clear the form obviously but I do not get the invalid property error so I am assuming it is within this section of code. Thank you for pointing me in the direction of the drop downs as I had set them to need a value. I will research around that area to see if I can get it to work. Thank you.

[Fluff13]

Do you have any change events eg

Please Login or Register  to view this content.

[jancliff]

No I dont have any change events. The only things i do have is code when the user form is activated.

Please Login or Register  to view this content.

Thank you for responding.

[jancliff]

Actualy - sorry thats not true I also have and AfterUpdate code on the cboType ;

Please Login or Register  to view this content.

sorry....

[Fluff13]

AfterUpdate is fine. But a Change event will fire when you clear the values, so I was thinking that may have been your problem

[jancliff]

I have uploaded the spreadsheet as i think I am getting confused..

[Fluff13]

It seems to be the cboType combo that's causing the problem, but not sure why.
Try replacing it & see if that fixes the problem

[Zer0Cool]

Easy approach is to simply unload and load the form:

Comment out everything under "clear data" including the setfocus line. Then add:

Please Login or Register  to view this content.

This will accomplish basically what you want to achieve, a new clean form to fill in. The downside is that the form (for me anyway) pop's back to its designated location instead of where I had placed it.

I think the long answer to your issue is how you are clearing the fields/controls. Its very likely that one or more of them require something other than "" to clear them. This could be something like xlNothing or some other property to clear it. I havent looked into it.

[jancliff]

That works a treat I hadn't thought of doing that fantastic thank you. I think it will work. I am trying to make sure the user cant leave a field blank at teh point of adding teh databut they can abandon their entries just by closing it. Ie a Close wont save but the add will (f that makes sense). Thanks again.

[jancliff]

I tried that but still got errors. I think I will do what Zer0Cool suggested as I think it may work ok for me - thank you so much for taking the time to have a look at it for me - I am super grateful

[Fluff13]

Does this work for you

[jancliff]

I just need to work out how to correctly filter them because a user can skip the first drop down and the second dropdown seems to remember the values from the previous load of the form. I need to research the "refresh" for want of a better word. Thanks everyone for your help.

[Zer0Cool]

The line causing the problem is (in the Private Sub CommandButtonAdd_Click()):

Please Login or Register  to view this content.

commented out the error does not occur. Not sure how to correct that, but that seems to be the cause of the issue