I have a form set up with numerous fields that I want to display data from
several tables I've populated from Excel files. But as there are numerous
files, I want to be able to make it so that you can select which set of files
you wish to see and then see only the pertinent data related to that file.
I've got the display form set up and it has a button which opens another form
which has a combo box to list the various choices. On a double click command
on any of the available choices I want the combo box form to close again and
bring up the first form, updated with the file data. I've dimensioned the
database and table as a readonly recordset and put in the "On Error" commands
in case the data is missing but I'm not sure how to proceed with making this
code write the data to the text boxes in the form.
Also my form is set up with certain cells in a subform within the original
form. The amount of data with each file varies so instead of having to create
the maximum number of textboxes to accomidate one file, I want the program to
fill in the row of text boxes in the subform and if there is another line of
relevant data, it will add another identicle line of text boxes to write the
next row of data to until it runs out. I know its been done before but I'm
pretty certain I don't know how to. Any advice out there?
|
Similar Threads
