form to edit records in A table. RRS feed

  • Question

  • Good day. 

    I have A table with 5 fields, which i have populated only 2 fields with data from a .xls which i imported into the table. 

    Please assist, or lead me in the right direction. 

    I need to fill in the remaining 3 fields with data - preferably through a ms access form. I also need to periodically add new records. 

    Ive attempted to design a form, with a combo box. therefore bringing up the field, and filling in the rest of the fields for the record, but i did not succeed. 

    Please help.
    Thursday, March 2, 2017 11:41 AM

All replies

  • Hi,

    You could try creating a form using the Wizard. For example, from the Navigation Pane, select the table and then click on the Create tab on the Ribbon and select Form.

    Hope it helps...

    • Proposed as answer by Chenchen Li Saturday, March 25, 2017 4:11 AM
    Thursday, March 2, 2017 4:15 PM