none
Populate data and data entry according to dropdown list RRS feed

  • Question

  • Hi, I know it's very easy and I'm a complete noob, so struggling to get a solution.

    So I have a form like this, where i want to be able to select the entry from the dropdown combo (marked 1) and depending on the selection, rest of the form data will populate. This is fine, and I can do it.

    But I cannot add record in the subform. If I tried, it says; "Cannot add record(s); join key of table not in recordset".

    I knwo it is because the database was not properly designed. Can you please help me to tell where I made the mistake?

    I attached the database here. Also I want to be able to enter data in green marked two columns from the dropdown list. the values are in tbl_agencies and tbl_quarter.

    Thanks and looking for your solution. 


    AdNaN



    Monday, November 4, 2019 1:50 PM

Answers

  • The record source of the subform should be tbp_Progress.

    The quarter_name control should be a combo box with:

    • Control Source = Quarter_ID
    • Row Source: tbl_Quarter
    • Column Count: 2
    • Column Widths: 0

    The Contributing Agency control should be a combo box with:

    • Control Source = Agency_ID
    • Row Source: tbl_Agencies
    • Column Count: 2
    • Column Widths: 0

    See https://www.dropbox.com/s/1eky3skc8p7r0cg/TestAdnan2.accdb?dl=1


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Adnan Hossain Monday, November 4, 2019 5:12 PM
    Monday, November 4, 2019 2:53 PM