Weird Issue with forms

[newbieaccess203]

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 ?

[June7]

Would have to review data structure and form design.

If you want to provide db for analysis, follow instructions at bottom of my post.

[newbieaccess203]

I've attach the full db and explain the problem again, unfortunately it did in new thread under:
need to display combo box selection match on the form instead separate query/datasheet view

[June7]

Different issues.

I am not having this issue. Open second form with main form button and edit record by selecting item in listbox - works fine.