DataType Mismatch (2 Viewers)

[Bigmo2u]

I get lthompson : Lori Thompson

Runtime error '3021
No current record

 

[Bigmo2u]

Does it make a difference the form is a Pop Up form?

 

[bob fitz]

What is the Record Source of the form.

 

[pr2-eugin]

lthompson is a String, so this should work, as long as the recordsource of the form contains the OwnerID field in it.

Dim rs As DAO.Recordset

Set rs = Me.Recordset.Clone
Msgbox Me.lstUsers.Column(0) & " : " & Me.lstUsers.Column(1)
rs.FindFirst "[OwnerID] = '" & Me.lstUsers.Column(0) & "'"
Me.Bookmark = rs.Bookmark

 

[Bigmo2u]

What is the Record Source of the form.

The recordsource of the form is tblOwner

 

[Bigmo2u]

pr2-eugin,

I get No current record found. after it displays the msgbox. but it does display info in the msgbox.

 

[bob fitz]

What is the data type of OwnerID in the table

 

[Bigmo2u]

Bob it is text

 

[pr2-eugin]

No offense, but on a scale of 1 to 10 where will you place yourself with MS Access proficiency?

Is ownerID field in the tblOwner table?

 

[bob fitz]

pr2-eugin,

I get No current record found. after it displays the msgbox. but it does display info in the msgbox.

What is the message.

 

[Bigmo2u]

lthompson : Lori Thompson

 

[bob fitz]

Can you post a copy of the db in A2003 mdb format for us to play with.

 

[Bigmo2u]

Okay, fixed it... The form property Data entry was clicked Yes and that is why it would not return the value on the form.

I am so sorry for wasting your time on this one. god I make some stupid mistakes.

Thank you for all your time and effort.

 

[bob fitz]

Okay, fixed it... The form property Data entry was clicked Yes and that is why it would not return the value on the form.

I am so sorry for wasting your time on this one. god I make some stupid mistakes.

Glad you have it working now.
Don't worry, we ALL make elementary mistakes some times. It's only the dammed computers that don't.
Hopefully, this is another lesson learnt for all of us.