Hi all,
I'm very new to VBA, so my question here may look stupid or has been
answered here a dozen times. Anyway I was not able to find the answers to my
question.
I have made a small Access database in which I have 4 tables.
Table one contains (in every table there is of course a ID field) the names
of products that we do analyses on, like wheat, flour, soyabeanmeal
Table two contains the sort of analyses that we do on these products, like
humidity, protein, etc
Table three contains different methods that can be used to do these
analyses, like ISO 712, EC, etc
Table four contains the fields from the previous three tables, where we make
all the possible combinations:
for example: wheat can be analysed on humidity by method ISO something, but
also by method ICC something.
Now I want to make a letter in a Word template that shows on startup a user
form with a number of comboboxes. In the first combobox the user can choose
a product let's say wheat. When the user then clicks on the following
combobox he will only see the different analyses possible for wheat, let's
say humidity. When he then clicks on the third combobox he will only see the
different methods that can be used to analyse the humidity of wheat.
All this information should then go to the appropriate bookmarks in the Word
document.
I managed to connect to the database, because I can load a list of
laboratories in a combobox that we can have these analyses assigned to (in
case we are too busy) and then put name, address, postcode, town, etc on the
appropriate bookmarks of the Word document.
Any help is greatly appreciated.
Luc