Dlookup funktion

me!Combo128 =[first name]+" "+[surname]

In your combo you could have two columns, one for the first name and one for surname.


Me!nationalty1 = DLookup("[citizen]", "crew database", "[first name]='" & me.Combo128.column(1) & "' AND [surname] = '" & me.Combo128.column(2) & "'")

columns in the combo are numbered from 0 to number of coulmns -1 and I am assuming that there is an ID in column(0). But this should giv eyou an idea :o)

Det virker ikke rigtig?

Private Sub Combo128_AfterUpdate()

'Me.position1 = " "
Me.nationality1 = " "
On Error GoTo err_name

'Dim Stringsearch As String

'Stringsearch = Me!Combo128
'Me!position1 = DLookup("[titel]", "crew database", "[first name]='" & Stringsearch & "'")
Me!nationality1 = DLookup("[citizen]", "crew database", "[first name]='" & Me.Combo128.Column(1) & "' AND [surname] = '" & Me.Combo128.Column(2) & "'")
'Me!nationality1 = DLookup("[citizen]", "crew database", "[first name]='" & Stringsearch & "'")
err_name:

End Sub

Combo boksen ser sådan ud!

SELECT [crew database].[ID], [first name]+" "+[Surname] AS Expr1 FROM [crew database];

Jan, add the [citizen] field to the combo and then

Me!nationality1 = me.combo128.column(3)

should work

You need to alter the Number of Columns paramater to 4!

Me!nationality1 = me.combo128.columns(3)

column

Arbejder på sagen!

'terry' hvorfor returnerer den Me.Combo128.Column(2) og ikke Me.Combo128.Column(3). I combo128 er tilføjet [position] ???

Private Sub Combo128_AfterUpdate()


On Error GoTo err_name

Me!nationality1 = Me.Combo128.Column(2)
Me!position1 = Me.Combo128.Column(3)

err_name:

End Sub

have you changed the parameter "Number of Columns" to 4?
Why have you added [position] ?

Ja, det har jeg nu og det virker, meeeen er der mulighed får at kun få vist en column i Combo128 nu ser jeg 2+1 =[first name]+[surmane] men også [citizen] ville gerne af med [citizen] så jeg kun ser navnet i Combo128

lets back up a bit!
You had two columns and have now added a new column citizen, so thats three columns. Now if you have added another column position you have four columns, so you need to change the property to 4

Har ændret til "column 4" og jeg får også min lookup til at virke, men min combo128 viser nu 2 kolonner, men vil gerne have at man kun kan se navnet og ikke som nu navnet og citizen

OK, there is a property "columns widths" or soemthing like that. You have to make sure that the columns which you dont want to see are set to 0
and example will be
0,1.5,0,0

So here only column 1 is visible

'terry' det var en lille fin finesse og det virkede. Tak for hjælpen IGEN

your meget welcome :o)