Error with listbox

T

Toan Chau

Hello everyone.

This is the query that I have....
----
OS Equipment Type Subject Notes
----

There are two items on the form.
1. List box
2. field with vaules for Notes

The list box get it's vaules from the query. It shows
every field except Notes.

I have a seperate field, on the form, that shows the
vaules for Notes. So when someone clicks on an item in
the list box, the vaules for Notes is shown in the Notes
field on the same form.

This works fine until I try to get the query to referance
the field OS to a text box on my form.

I give the query a critiea on the OS field that references
to a text box in a form.

Based on what I put in that text box the query will
generate the result onto a listbox in that same form.

This works up to the point of filtering the correct vaules
based on what I put in the text box. But when I click on
the result vaules in the list box, instead of seeing the
corresponding record in the Notes field I get this error..

Run-time Error '3201'
No Current Record

--When I click on debug I get this message..

Sub List12_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Subject] = '" & Me!
[List12] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

With "Me.Bookmark = Me.RecordsetClone.Bookmark" being
highlighted.


Can anyone please help me out?

Thanks! Toan
 

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

Top