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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2 point question--combo boxes

Status
Not open for further replies.

goatsaregreat

Programmer
Mar 21, 2001
82
GB
I have a combo box that I want to include all records in a database. That way the user can input his/her own data. Anyway, is there a property or anything to do this? I know that I can code it, but that brings me to point #2. This is the code I am using to set my recordset.

dim db as database
dim rs as recordset
Set db = OpenDatabase("C:/My Documents/Berry2.mdb")
Set rs = db.OpenRecordset("years")

This returns an error on the "set rs" line every time. I have coded things like this before with no problems. The error is ,"Type mismatch"!! Please help me.

TIA for your help.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top