I've solved the problems I had setting up a form to enter the ANZLIC Metadata Elements. Combobox 1 has a category list which when selected, populates a second combobox with the titles in the selected category. I wanted a text box to fill with the definition of the title selected, and finally it's all working beautifully. No query at all for the text box. Instead I added an after_update code to the title that said to send the contents of column 4 - the definition(which I added to the title query) to the textbox.
After much searching I finally found a forum thread which talked about a similar problem, and I was able to modify the code to suit myself. No programmer certainly, but like a dog with a bone I don't let go until it's done with! It's only taken a week of hair-pulling to create one form! In the meantime I've learned alot about queries and sql statements, and the frustations of working with databases.
Recent Comments