Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: paulrmiller2000
- Order by date
-
Combo box event generates a Type mismatch error
Hi Ace, it sure is! I just downloaded it to make sure I didn't upload the wrong file. The module you've been graciously helping me with corresponds to frm_Leads. Thanks, Paul- paulrmiller2000
- Post #18
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
Hi AceMan, I am using Access 2000k. Assuming I did everything correctly, here's the link: http://www.4shared.com/file/115968063/ffa4e1d1/Prospecting_-_Shared.html. Try to keep the laughter to a minimum, it is far from complete and definitely an amateur's! ;-) But hey, I figure it's a...- paulrmiller2000
- Post #16
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
AceMan, Thank you for taking the time to write that out! I did as you instructed, and received the following error when attempting to open the form: "Microsoft Access can't find the field 'cbxLS' referred to in your expression," and debugger highlighted the following line in the public sub...- paulrmiller2000
- Post #14
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
AHA! See, I just KNEW I had gotten stupid after taking a few years off! That's so simple I can't believe I didn't see it. Making your change did it for the update procedure. However, one problems till remains, and I'm sure it's just as obvious a solution. Say my current record does NOT...- paulrmiller2000
- Post #12
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
Hi everyone, thanks for the replies! kjv1611, yes I have commented out those two lines and have had no issues. By process of elimination I am confident there's some issue with the combo box itself or the way I'm trying to handle it. TheAceMan1, I don't think that's possible, since each row in...- paulrmiller2000
- Post #9
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
Yes... but I did just double-check again, because you never know! pk_lonReferralTypeID is a long integer (and auto-number) in tbl_ReferralTypeID. It's corresponding field in tbl_Leads, fk_lonReferralTypeID, is also a long integer.- paulrmiller2000
- Post #5
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
Hi MajP, Rowsource for cboReferralType is SELECT pk_lonReferralTypeID, txtDescription FROM qry_ReferralTypes; I am convinced the problem originates with the cboReferralType combo box, either from the way it is structured or from the way the event is written. I also tried deleting it...- paulrmiller2000
- Post #3
- Forum: Microsoft: Access Forms
-
Combo box event generates a Type mismatch error
I am stumped! I have a form built on this table: tbl_Leads pk_lonLeadID fk_lonClientID fk_lonLeadSourceID fk_lonListingTypeID fk_lonMaketingTypeID fk_lonReferralTypeID fk_lonAgentID Each field is a Long integer. The form has several combo boxes, populated by queries, that are bound to these...- paulrmiller2000
- Thread
- Replies: 19
- Forum: Microsoft: Access Forms
