CLEAR COMBO BOX FIELD

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I trying to clear the content typed in this field which came from a query by
using
Me.[MATRIXID] = Null

I get running time error.
"You tried to assign the Null value to a variable that is not a Variant data
type."

How do I get this to work?

Thanks
 
Have you tried either:
Me.MATRIXID.UnDo
or
Me.MATRIXID = ""

I trying to clear the content typed in this field which came from a query by
using
Me.[MATRIXID] = Null

I get running time error.
"You tried to assign the Null value to a variable that is not a Variant data
type."

How do I get this to work?

Thanks
Click to expand...
 
My row source for the field is
SELECT [LG Packaging Matrix].[MATRIXID], [LG Packaging Matrix].[UPC], [LG
Packaging Matrix].[SKU], [LG Packaging Matrix].[CUSTOMER], [LG Packaging
Matrix].[DESCRIPTION] FROM [LG Packaging Matrix] ORDER BY [LG Packaging
Matrix].[SKU];

I would like to clear this field but get running time error message. "You
tried to assign the Null value to a variable that is not a Variant data type."

Any help would be appreciate.



ruralguy via AccessMonster.com said:
Have you tried either:
Me.MATRIXID.UnDo
or
Me.MATRIXID = ""

I trying to clear the content typed in this field which came from a query by
using
Me.[MATRIXID] = Null

I get running time error.
"You tried to assign the Null value to a variable that is not a Variant data
type."

How do I get this to work?

Thanks
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
Hi Ashley,
We have a slight communication problem. ComboBox and ListBox controls have a
RowSource
but TextBoxes have a ControlSource and a form has a RecordSource. I'm not
sure what you are describing. What type of field is the [LG Packaging Matrix]
..[MATRIXID] field?
My row source for the field is
SELECT [LG Packaging Matrix].[MATRIXID], [LG Packaging Matrix].[UPC], [LG
Packaging Matrix].[SKU], [LG Packaging Matrix].[CUSTOMER], [LG Packaging
Matrix].[DESCRIPTION] FROM [LG Packaging Matrix] ORDER BY [LG Packaging
Matrix].[SKU];

I would like to clear this field but get running time error message. "You
tried to assign the Null value to a variable that is not a Variant data type."

Any help would be appreciate.
Have you tried either:
Me.MATRIXID.UnDo
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
data type of the [LG Packaging Matrix].[MATRIXID]field is number

ruralguy via AccessMonster.com said:
Hi Ashley,
We have a slight communication problem. ComboBox and ListBox controls have a
RowSource
but TextBoxes have a ControlSource and a form has a RecordSource. I'm not
sure what you are describing. What type of field is the [LG Packaging Matrix]
.[MATRIXID] field?
My row source for the field is
SELECT [LG Packaging Matrix].[MATRIXID], [LG Packaging Matrix].[UPC], [LG
Packaging Matrix].[SKU], [LG Packaging Matrix].[CUSTOMER], [LG Packaging
Matrix].[DESCRIPTION] FROM [LG Packaging Matrix] ORDER BY [LG Packaging
Matrix].[SKU];

I would like to clear this field but get running time error message. "You
tried to assign the Null value to a variable that is not a Variant data type."

Any help would be appreciate.
Have you tried either:
Me.MATRIXID.UnDo
Click to expand...
[quoted text clipped - 12 lines]
Thanks
Click to expand...
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
Integer, LongInteger, Single, Double, Currency???
Where do you have your code to clear the field and what type of control is
displaying the field?
Did you try Me.MATRIXID.UnDo? What was the result?
data type of the [LG Packaging Matrix].[MATRIXID]field is number
Hi Ashley,
We have a slight communication problem. ComboBox and ListBox controls have a
Click to expand...
[quoted text clipped - 19 lines]
Click to expand...
 
It is LongInteger. I have the code in the event procedure on click. I am
trying to clear the combo box.

Me.MATRIXID.UnDo did not clear the combo box I want to clear.

Thanks

ruralguy via AccessMonster.com said:
Integer, LongInteger, Single, Double, Currency???
Where do you have your code to clear the field and what type of control is
displaying the field?
Did you try Me.MATRIXID.UnDo? What was the result?
data type of the [LG Packaging Matrix].[MATRIXID]field is number
Hi Ashley,
We have a slight communication problem. ComboBox and ListBox controls have a
Click to expand...
[quoted text clipped - 19 lines]
Thanks
Click to expand...
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
What is the name of the ComboBox you want to clear?
It is LongInteger. I have the code in the event procedure on click. I am
trying to clear the combo box.

Me.MATRIXID.UnDo did not clear the combo box I want to clear.

Thanks
Integer, LongInteger, Single, Double, Currency???
Where do you have your code to clear the field and what type of control is
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Is the ComboBox bound to a field? Does it have a ControlSource?
It is LongInteger. I have the code in the event procedure on click. I am
trying to clear the combo box.

Me.MATRIXID.UnDo did not clear the combo box I want to clear.

Thanks
Integer, LongInteger, Single, Double, Currency???
Where do you have your code to clear the field and what type of control is
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Yes, it is bound. the controlsource is MATRIXID.


ruralguy via AccessMonster.com said:
Is the ComboBox bound to a field? Does it have a ControlSource?
It is LongInteger. I have the code in the event procedure on click. I am
trying to clear the combo box.

Me.MATRIXID.UnDo did not clear the combo box I want to clear.

Thanks
Integer, LongInteger, Single, Double, Currency???
Where do you have your code to clear the field and what type of control is
Click to expand...
[quoted text clipped - 8 lines]
Thanks
Click to expand...
Click to expand...

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
Back
Top