opdater felt i tabel fra VBA

wizzcat can you give more informatio.

whenn you say \"kalde me.xxx og få den nyværende værdi\" can I see your code?

Do you want to put somethng in me.xxxx?

me.xxx = 1  for numbers
me.xxx = \"Test\" for string

The field has to be \"Bound\" to the field in the table

I can call the me.(attribute name) and get the curent value of a field on my form, that is bound to at table. fine.

But i cannot manipulate the content and return it to the field (including updateing the underlying table.

So how do I change the value of an attribute on the form and thereby in the underlying table.?

the code goes like this but does not compile since me.context is read only

Private Sub cmdFireTalUdskift_Click()
    Dim myString As String
    myString = Me.Context
    Me.Context = ChangeNumberToText(myString)
......

wizzcat

me.YourFieldName = ChangeNumberToText(myString)

Can you enter data directly into the field without converting to text ChangeNumberToText?

The way you are doing it looks correct, but I cant see what ChangeNumberToText returns, or what the underlaying table/field looks like.

If the field in the database is a number and ChangeNumberToText returns a none numeric value then you will get an error saying that the value youenterd isnt valid for this field.
If that is the case then lookk at the function ChangeNumberToText and get it to work!