CLEAR COMBO BOX FIELD

[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

 

[ruralguy via AccessMonster.com]

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

 

[Guest]

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
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

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

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

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

[quoted text clipped - 12 lines]

 

[Guest]

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
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

[quoted text clipped - 12 lines]

Thanks

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

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

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

[quoted text clipped - 19 lines]

 

[Guest]

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
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

[quoted text clipped - 19 lines]

Thanks

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

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

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

[quoted text clipped - 8 lines]

 

[ruralguy via AccessMonster.com]

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

[quoted text clipped - 8 lines]

 

[Guest]

Yes, it is bound. the controlsource is MATRIXID.

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

[quoted text clipped - 8 lines]

Thanks

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

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

Try: Me.MATRIXID = Empty

Yes, it is bound. the controlsource is MATRIXID.

Is the ComboBox bound to a field? Does it have a ControlSource?

[quoted text clipped - 10 lines]

 

[Guest]

Thank you, it works!

Try: Me.MATRIXID = Empty

Yes, it is bound. the controlsource is MATRIXID.

Is the ComboBox bound to a field? Does it have a ControlSource?

[quoted text clipped - 10 lines]

Thanks

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

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

You are welcome.

Thank you, it works!

Try: Me.MATRIXID = Empty

[quoted text clipped - 5 lines]