find a control in a continuos form

[diegomarino]

hi
i'd like to get the value i marked in the picture, it's the second record; consider that the value you see is the column(1) of the combobox(so i can't loop using me.recordsetclone cause i can't use rs!combobox.column(1))

how can i do that? i found something about looping throgh controls in a form but it didn't work

[pbaldy]

Try using GoToRecord to go to the desired record and then using the combo reference to get the value.

[ranman256]

you already know the name: cboName
you dont use recordset field, call it by the control name.

[Gicu]

I think the easiest would be a simple dLookup on the combo's row source.

Cheers,

[diegomarino]

thanks very much, i used a recordset based on a query, with dlookup will be a really mess cause i had to make a three time nested dllookup at least

[Gicu]

Could you post a small sample with just the objects involved and some dummy data to illustrate the issue?

Cheers,

[diegomarino]

it's not that big deal, it's just a form (a single event calendar) with subform (people involved in the event); the subform has some fields, the name of the partecipant, the qualification (customer, applicants etc etc) and the Deal, that is unique for every applicant but is related to a customer and the customer is related to a company
this is the query i use (instead of dlookup) to get the name of my customer relaterd to the deal

"SELECT Aziende.Azienda " & vbCrLf & _                             "FROM Aziende INNER JOIN ((Trattative INNER JOIN Partecipanti ON Trattative.IDtrattativa = Partecipanti.TrattativaID) INNER JOIN Clienti ON Trattative.ClienteID = Clienti.IDCliente) ON Aziende.IDazienda = Clienti.AziendaID " & vbCrLf & _
                             "WHERE (((Partecipanti.CalendarioID)=" & Me.IDCalendario & "));")

[Welshgasman]

You can retrieve more than one data item with a single DlookUp() as long as the criteria remains the same?

[diegomarino]

if i understood, the answer is no. You can get just one data item with dlookup. Speaking of my case, it's just laziness, it's a bit tricky to use dlookup in this case and use recordest is a shorter way that works perfectly...

[Welshgasman]

if i understood, the answer is no. You can get just one data item with dlookup. Speaking of my case, it's just laziness, it's a bit tricky to use dlookup in this case and use recordest is a shorter way that works perfectly...

Incorrect.

var = Nz(DLookup("[Field1] & '|' & [Field2]", "tblRma", "[Field3]= " & Me.MyTextboxName), "")

? dlookup("Client & '|' & CMS", "Emails", "ID=3")
Mrs J.Firth:125521|125521