I get lthompson : Lori Thompson Runtime error '3021 No current record
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #21 I get lthompson : Lori Thompson Runtime error '3021 No current record
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #22 Does it make a difference the form is a Pop Up form?
bob fitz AWF VIP Local time Today, 23:44 Joined May 23, 2011 Messages 4,726 Apr 28, 2014 #23 What is the Record Source of the form.
pr2-eugin Super Moderator Local time Today, 23:44 Joined Nov 30, 2011 Messages 8,494 Apr 28, 2014 #24 lthompson is a String, so this should work, as long as the recordsource of the form contains the OwnerID field in it. Code:Copy to clipboard 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
lthompson is a String, so this should work, as long as the recordsource of the form contains the OwnerID field in it. Code:Copy to clipboard 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
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #25 bob fitz said: What is the Record Source of the form. Click to expand... The recordsource of the form is tblOwner
bob fitz said: What is the Record Source of the form. Click to expand... The recordsource of the form is tblOwner
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #26 pr2-eugin, I get No current record found. after it displays the msgbox. but it does display info in the msgbox.
pr2-eugin, I get No current record found. after it displays the msgbox. but it does display info in the msgbox.
bob fitz AWF VIP Local time Today, 23:44 Joined May 23, 2011 Messages 4,726 Apr 28, 2014 #27 What is the data type of OwnerID in the table
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #28 Bob it is text
pr2-eugin Super Moderator Local time Today, 23:44 Joined Nov 30, 2011 Messages 8,494 Apr 28, 2014 #29 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?
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 AWF VIP Local time Today, 23:44 Joined May 23, 2011 Messages 4,726 Apr 28, 2014 #30 Bigmo2u said: pr2-eugin, I get No current record found. after it displays the msgbox. but it does display info in the msgbox. Click to expand... What is the message.
Bigmo2u said: pr2-eugin, I get No current record found. after it displays the msgbox. but it does display info in the msgbox. Click to expand... What is the message.
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #31 lthompson : Lori Thompson
bob fitz AWF VIP Local time Today, 23:44 Joined May 23, 2011 Messages 4,726 Apr 28, 2014 #32 Can you post a copy of the db in A2003 mdb format for us to play with.
B Bigmo2u Registered User. Local time Today, 17:44 Joined Nov 29, 2005 Messages 200 Apr 28, 2014 #33 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.
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 AWF VIP Local time Today, 23:44 Joined May 23, 2011 Messages 4,726 Apr 28, 2014 #34 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. Click to expand... 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.
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. Click to expand... 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.