Combo Box Question

[JimUK]

I have several combo boxes on my form and for the text fields I have no problem. One of the records is a number and am having a problem figuring out what I should call in the Row Source.

How would I change the following for a number vice text?

Select Distinct [pmi].[number] From [pmi] Where [pmi].[number] Is Not Null


Thanks,

Jim

 

[jrbarnett]

No change is necessary to the SQL to pick up numeric or text fields. You just have to make sure that any field bound to the combobox is set to the appropriate data type.

John