Delete a command button after first use 1

[Eprice]

Hi,
I have a command button (cmdNAICS) that is importing data into a database. I only want them to use this button one time so i am trying to delete the button after the import is finished. The form is (frm MainMenu). I found code for DeleteControl but get different errors depending on what I try. Does anyone know the correct code to delete a button on a form that has already been created?
Thanks Lisa

 

[randy700]

Don't know about actually deleting the button, but you could simply set it's visible property to false. Make sure you set focus to another control first.


Randy

 

[Eprice]

Yes, that works fine until they close the database and come back in. Then it is visible and enabled again.
Lisa

 

[bubba100]

Add a field to the table bound to your form. Then add a checkbox to your form, bind it to that field. Add to your code that make the button not visible with me!checkbox.value=-1. Now the form can "remember" that you have completed the download. In the Onopen event of the form if me!checkbox=-1 then me!cmddownload.visible=false else me!cmddownload.visible=true.

 

[Eprice]

Yes, I had already thought of that too but was trying to get it done with a couple lines of code. Thanks for the help.
Lisa