as i declare the first one field is combobox and another one is text box. then if click the combobox value then corresponding text value to be displayed on text box.how to proceed to coding in ms access.

  1. Polulate the combo box by querying a specific field of a table from DB.
  2. while selecting the value from combo, pass the value from the combo back to the SQL query.
  3. Execute the sql in the and capture the values from DB.(ensure that you get only a single value returned from DB)
  4. Display in the textbox.