Data-bound combo box
Posted on 1998-08-30
I am trying to write a simple recipe management program, using a data control and a data-bound combo box. I want the combo box to be populated using all the recipe names on file for a certain category (e.g., list all the recipes from the "Appetizers" category). My data control's RecordSource property is a query (list all recipe names where the category = "Appetizers"). The combo box populates correctly, but when I select one of the entries, my other text boxes are not updated with the data for that recipe (even though their DataSource and DataField properties point to my database). If I put in a Data1.Refresh in the dcCombo_Change event, the combo box text is always changed back to the original selection. How do I update the current record to indicate a new selection from the combo box?