Recent content by Bigmo2u

Run-time Error: An arguement topdate function was invalid. The field name must be provided as a string value in quotation marks. I have never got this before. I have this same code on other forms, but using other tables and it works just fine. Private Sub lstSearch_AfterUpdate() Dim rs As...

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.

lthompson : Lori Thompson

Bob it is text

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

The recordsource of the form is tblOwner

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

I get lthompson : Lori Thompson Runtime error '3021 No current record

If i do: rs.FindFirst "[OwnerID] = " & Str(Me.lstUsers) I get dataType mismatch

No current record found '3021', but the msgbox is still showing the names.

Compile error: Syntax error DAO.rs AS Recordset

Bob Rowsource Property is: SELECT tblOwner.OwnerID, tblOwner.FullName FROM tblOwner WHERE (((tblOwner.OwnerID)<>"<---SELECT--->"));

pr2-eugin properties are as follows: Bound Column 1 Column Count 2 column 1 = OwnerID COlumn 2 = FullName Column widths = 0";1.5"

Bob if I change it variable back to rs as Object I get lthompson and ltompson in the msgbox

Bob I am getting the word: and in the msgbox