Reset Button

[misschanda via AccessMonster.com]

Hello
I have a reset button on form; however when ever i use the button i get the
following error: "method or data member not found:"

I have checked the query from which i made and everything and can't find
error.

I also rearranged the sql from:
Me.txtProduct Name = Null
Me.cboProduct Application = Null
Me.cboOperator = "="
Me.txtdiametermeters = Null
Me.txttsr No = Null
Me.cbopolymer Abbreviation = Null
Me.cbosupplier = Null

to new arrangement of :
Me.cboProduct Application = Null
Me.cboOperator = "="
Me.txtdiametermeters = Null
Me.txttsr No = Null
Me.cbopolymer Abbreviation = Null
Me.cbosupplier = Null
Me.txtProduct Name = Null

to remove the line that the error shown and in doing so the error still shows
at the begining of code:

do you have any suggestions to what could be happening??

Thanks
LA

 

[Klatuu]

That is not SQL, it is VBA code.
It would be helpful if you indentify on which line the error is occurring.

 

[Gen]

Instead of Null try "", for example:

Me.txtProduct Name = ""

I have a similar reset button and this code works for me.

 

[misschanda via AccessMonster.com]

Hello
I am still having issues with this code..
I switch from Null to "" and experienced the same issues.
I am noticing that the fields olymer Abbreviation/ Product Application and
size.
Are there any reasons why these particular fields are not "searching" the
table as designed??

thanks
La

Instead of Null try "", for example:

Me.txtProduct Name = ""

I have a similar reset button and this code works for me.

Hello
I have a reset button on form; however when ever i use the button i get the

[quoted text clipped - 28 lines]

Thanks
LA

 

[Klatuu]

The problem is your naming convention. At least four of your control names
have spaces in them. Spaces should NEVER be used in any name. You should
use only letters, numbers, and the underscore character in names.

You should rename these controls:

Me.txtProduct Name = Null
Me.cboProduct Application = Null
Me.txttsr No = Null
Me.cbopolymer Abbreviation = Null


Or enclose the names in braces:

Me.[txtProduct Name] = Null
Me.[cboProduct Application] = Null
Me.[txttsr No] = Null
Me.[cbopolymer Abbreviation] = Null


--
Dave Hargis, Microsoft Access MVP

Hello
I am still having issues with this code..
I switch from Null to "" and experienced the same issues.
I am noticing that the fields olymer Abbreviation/ Product Application and
size.
Are there any reasons why these particular fields are not "searching" the
table as designed??

thanks
La

Instead of Null try "", for example:

Me.txtProduct Name = ""

I have a similar reset button and this code works for me.

Hello
I have a reset button on form; however when ever i use the button i get the

[quoted text clipped - 28 lines]

Thanks
LA