Search results

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

Changed to rs As DAO.Recordset and still get he same error. Now and I am getting no record found.

pr2-eugin ~ Thank you for the advice, but I know the record is there. they can only select from a listbox of choices, so they can't enter there own data to do the search.

Having a an issue and not sure how this is happenning because I have used this code in a lot of forms. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[OwnerID] = '" & Me![lstUsers] & "'" Me.Bookmark = rs.Bookmark <---- error is here for the datatype mismatch or No record found...

Stupid Me, I found the error. Dim rs AS DAO.Database S/B Dim rs AS DAO.Recordset

Spikepl ~ I udated the code. the Read shows the error. i cant see what you put out there as a suggestion either.