populate combo box with foreign query

[brian.capel]

I have a combo box that I would like to populate with data from a table
that is not part of my Access database (a mainframe table). So far I
have used a valuelist that I populate from a recordset. But if there
are more than 500 records and I show 30 characters of data per record I
hit the 2056 string limit of the recordsource property. Can I populate
the combo box any other way with my mainframe data?

Thanks, Brian

 

[Douglas J. Steele]

You could import the data into a table in Access and use that, or you could
try using the function shown in
http://msdn2.microsoft.com/en-us/library/aa196557(office.11).aspx (don't
worry that it says Access 2003 if you're using an earlier version: it's the
same function for all versions)