Unbound listbox

[Brian]

Hallo,

I have a unbound listbox. The OGID field is of type text.

The below code is based on a OGID field of type number. How do i change the
code to address the OGID text field? Thanx in advance for any suggestions.
Tried various coding but no succes.


Me.[OGList].Value = Me.[OGID].Value

Me.RecordsetClone.FindFirst "[OGID] = " & Me![OGList]
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.[OGList].Value = Me.[OGID].Value


Regards,
Brian

 

[Douglas J. Steele]

Me.RecordsetClone.FindFirst "[OGID] = " & Chr$(34) & Me![OGList] & Chr$(34)

 

[Harmannus]

Hallo,

Thanx for the reply.

I will give it a try.

Brian

Me.RecordsetClone.FindFirst "[OGID] = " & Chr$(34) & Me![OGList] & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hallo,

I have a unbound listbox. The OGID field is of type text.

The below code is based on a OGID field of type number. How do i change the
code to address the OGID text field? Thanx in advance for any suggestions.
Tried various coding but no succes.


Me.[OGList].Value = Me.[OGID].Value

Me.RecordsetClone.FindFirst "[OGID] = " & Me![OGList]
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.[OGList].Value = Me.[OGID].Value


Regards,
Brian