I have created a form on which I created commandbutton, clicking which opens another form which have prefilled listbox which when i select add data to table.
when i open the second form (with listbox) i am able to select option from listbox and it successfully adds that data to table
but when i open the main form which has commandbutton and by clicking that command button when i go to second form (which has listbox), I cannot edit/select listbox option and it gives me message "The Recordset is Unupdatable" , also after this if i try to open the second form (with listbox) directly it gives me the same message "The Recordset is Unupdatable".
Only time it allows me to update/select option from listbox is if i open the database and open the second form (one with listbox) directly first.
does anyone know what is going on ?