Find værdi

Er feltet Status fra en anden tabel end din form får data fra?

If I understand your question correctly you have a related table where the table (status) contains the fields StatusID and Mappe. And maybe other fields too.

If that is correct tyhe you dont need any code to show the value for Mappe. Just change the field containing StatusID to a combo which contains th evalues from the table Status

Here is some info on how to use a combo to see values from a related table

http://www.trigonblue.com/AccessLookup.htm

Ved ikke helt om jeg har forstået dit spørgsmål rigtig, men svare udfra hvad jeg formoder du mener.

Ja
Har en tabel Sager hvor i der bl.a. er et felt StatusId den StatusId skal jeg så bruge til at slå op i min tabel Status hvor i jeg har tre felter StatusId, Status og Mappe det er så det felt Mappe og skal have lagt ind i en variabel som jeg skal bruge senere i koden.

Det er den værdi der står i StatusId i formen der blever gemt i StatusId i tabellen Sager

terry

My problem is not to see the Text in the combo.

In my VBA code, i have to use the vaule from the i field Mappe in the table Status. In the combo box i see the value form the field Status in til table Staus and save the related value form StstusId in the table Sager

Try and explain what table/fields you have on the form and what you want to do with the data in the form.

Are you trying to find a value from another table, or do you want to write a value to another table?

In my form I select the Status and it save the related StatusID to the table Sager

In my VBA code I want to use the StatusId from the table Sager to find the related value in the field Mappe in the tabel Status.
This Mappe value it have to write in a variable then I can use it later in my code

SomeVariable = Dlookup("Mappe","Status","StatusID = " & Me.StatusID )

Thank you, that was very easy when man know the functions

:o)

and thanks