By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Assigning a Data Type to a Combo in VBA

P: n/a
A2003, XP Pro SP2

I have a combo box set to look up field names from a table. I want to
be able to get the data type of the field chosen by the combo and assign
that type to another combo box that is used to look up the values in
that chosen field.

I'm using this to get the data type:

Dim intType As Integer
intType = Me.RecordsetClone.Fields(cbfField1).Properties("Ty pe")

which works (returns 4 for "Long") but how do I assign the result to
another combo?

Many thanks.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.