Getting Data from Access into an Excel Userform

[phendrena]

Hi there,

How would I go about getting data from Access into an Excel userform?
I've attached a zip that contains the excel file and also the access file.

In excel the form is frmCNSearch and the data would come from the Access table Manual_Covernote_Log.

Thanks,

[CreganTur]

I haven't looked at the files you posted, but I can tell you that the asnwer is a connection- either DAO or ADO. Pull the records you want from Access in a recordset, and then use VBA to pull the values for the different fields out of the recordset and push them to the textboxes and other objects on your UserForm.

HTH:thumb

[phendrena]

I haven't looked at the files you posted, but I can tell you that the asnwer is a connection- either DAO or ADO. Pull the records you want from Access in a recordset, and then use VBA to pull the values for the different fields out of the recordset and push them to the textboxes and other objects on your UserForm.

HTH:thumbHi,

I'm currently using an ADO connection to send data from the excel file (frmDSTCallLog) into both of the Access tables (Inbound_Call_Log and Manual_Covernote_Log). Getting the back, populating the listbox and then populating the other fields on the form (frmCNSearch) based on what is selected in the listbox.... not clear on how to do that tbh.