Unbound listbox

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
 
D

Douglas J. Steele

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

Harmannus

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unbound listbox 1
Addressing listbox 4
Bug 1 mdb With Tab Control works fine. Bugs with mde 7
Finding Records 7
Referring to multiple columns in a listbox 3
auto populate text box based on combo box value 1
Run-time error '2115' 4
Listbox AfterUpdate 2

Top