Update combo box from recordset

[kc1]

Hi



I need help as I can't seem to find a solution anywhere.

I have written code to retrieve data from a back-end, that is then bound to a form (late binding forms).
From the retrieved record set I want to update a combo box using 1 field from the data in the record set, only showing unique records in the list.

Please could someone help me with this?

Thanks

KC

[hertfordkc]

records?

Are you familiar with DISTINCTROW?
http://office.microsoft.com/en-us/ac...001231351.aspx

If you are struggling with the combobox, can you be more specific?

Hi

I need help as I can't seem to find a solution anywhere.

I have written code to retrieve data from a back-end, that is then bound to a form (late binding forms).
From the retrieved record set I want to update a combo box using 1 field from the data in the record set, only showing unique records in the list.

Please could someone help me with this?

Thanks

KC

[kc1]

Yeah, I'm familiar with Disticnt.
This is what currently happens, when an unbound form and subform are opened, event code is run that bounds a record set to the subform, this record set is from the back end database.
On the form there is a combo box, I want this combo box to be populated with unique values from 'Field1' from the record set now bound in the subform.
Where is this record set stored and can I keep using it for such actions?
Perhaps I should just append this record set to a table and use that to determine the combo box values. (how, I don't know either?)

[hertfordkc]

would have the recordset pointer, which should suffice to set the Combobox recordsource. Since the subform event code has the pointer, this code should probably set the recordsource.
After binding, does the event code do a "Me.requery"? You should have the combobox set before the requery, or you may have to execute another requery.

Yeah, I'm familiar with Disticnt.
This is what currently happens, when an unbound form and subform are opened, event code is run that bounds a record set to the subform, this record set is from the back end database.
On the form there is a combo box, I want this combo box to be populated with unique values from 'Field1' from the record set now bound in the subform.
Where is this record set stored and can I keep using it for such actions?
I don't think the recordset's location is important. You should be able to use the recordset until it is closed. Do you know where or when the recordset is opened or closed? Is it a global variable?
Perhaps I should just append this record set to a table and use that to determine the combo box values. (how, I don't know either?)
This shouldn't be necessary.

[kc1]

I know where I open and close the record set, and it's global.
I take it I need to the update to combo box before I close the recordset- but I need help with the exact coding.
Could you provide this for me please?

[hertfordkc]

should be easy. However, I doubt that my effort in that direction would be of much help.
Can you remove any confidential info from your database, compact it, zip it if necessary and post it.

I know where I open and close the record set, and it's global.
I take it I need to the update to combo box before I close the recordset- but I need help with the exact coding. I believe the recordset would have to remain open for as long as the combobox is functional. If this is a problem, then perhaps you will have to create a local table.
Could you provide this for me please?