My hope is to be able to systematically compare a forecast with historical data. We will receive each in the form of a table and import them.
The first step is a combo box that lists the names of the tables in the database, and the user will then select which table is the forecast for comparison. This part is done, and the combo box is called cboForecast. A typical forecast contains an ID number and 6 forecast periods (months).
i need the user to select the fields that are the time periods (i.e. each month's forecast field) and specify the associated period (i.e. 20090601). The forecasts are 6 months of data each, so i will need 6 combo boxes, each of which lists the field names from the table that was selected in the above paragraph, the name of which table is now the value of cboForecast. There will also be 6 text boxes for the user to enter the period (20090601).
This is the part i need help with. Can you help me with code that will list a table's field names in a combo box? Thanks!
The first step is a combo box that lists the names of the tables in the database, and the user will then select which table is the forecast for comparison. This part is done, and the combo box is called cboForecast. A typical forecast contains an ID number and 6 forecast periods (months).
i need the user to select the fields that are the time periods (i.e. each month's forecast field) and specify the associated period (i.e. 20090601). The forecasts are 6 months of data each, so i will need 6 combo boxes, each of which lists the field names from the table that was selected in the above paragraph, the name of which table is now the value of cboForecast. There will also be 6 text boxes for the user to enter the period (20090601).
This is the part i need help with. Can you help me with code that will list a table's field names in a combo box? Thanks!