Unbound listbox

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
Me.RecordsetClone.FindFirst "[OGID] = " & Chr$(34) & Me![OGList] & Chr$(34)
 
Hallo,

Thanx for the reply.

I will give it a try.

Brian

Douglas J. Steele said:
Me.RecordsetClone.FindFirst "[OGID] = " & Chr$(34) & Me![OGList] & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Brian said:
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
Click to expand...
Click to expand...
 
Back
Top