update sells price after

[togur]

I have a Combo-box in a form with 2 Columns - ProduktName and sellprice
I used a code :
Private Sub ProduktName_AfterUpdate()
sellsprise = ProduktName.Column(2)

The problem is:
When i lselected the produktname , is coming correct the sellprice,
after geting the new record the last price is seeing - (200)
when the new produkt name is selcted is coming the new sellsprice
I want to be empty the sell price before i am geting the new produkt name
See the foto please

 

[Minty]

In the Current Event of the form, you would need to reset any unbound fields to Null.

 

[togur]

How to reset to Null, please ?
The unbound filed is called " CmimShitje"
Can you tell me the code
thanks

 

[theDBguy]

How to reset to Null, please ?
The unbound filed is called " CmimShitje"
Can you tell me the code
thanks

Hi. Welcome to AWF!

Can you please confirm if CmimShitje is bound or unbound? What is in its Control Source property?

 

[Minty]

Assuming CminShitje is Unbound - In the Forms Current Event something like

If IsNull(Me.ProduktName) Then
   Me.CminShitje = Null
Else
   Me.CminShitje = Me.ProduktName.Column(2)
End If

 

[togur]

Hi. Welcome to AWF!

Can you please confirm if CmimShitje is bound or unbound? What is in its Control Source property?

The box "CmimShitje" is unbound!
see the foto please

 

[theDBguy]

The box "CmimShitje" is unbound!
see the foto please

In that case, you could try putting this in its Control Source property.

=[ProduktName].[Column](2)

 

[arnelgp]

also see the Form's Before/After Update event if
there is code Setting the [Price]'s Default Value.