Recordset is unupdateable

[MdHaziq]

Hello,
Forum

I am stuck with this problem of using frmLog to make a selection of items in the updating list which is appended from tblAddNew.

I want to show what is in the combo box after the selection has been made in a textbox beside. When I did that, the form stopped working.

Can someone help me?



TIA

Haziq

[CJ_London]

rule is one table, one form. By adding a second table to your form recordsource, it no longer becomes updateable.

instead, remove the tblUpdating from the recordsource and change the control source for the subsystem control to

=itemid.column(1)

Repeat for the other controls with the relevant column number.

Note, it should not be necessary to show the ID field since this should be a system field on no interest to the user

[June7]

NewItemID in tblUpdating needs to be designated as primary key because this value is being saved into ItemID of tblLog. I don't see need to include tblUpdating in the form RecordSource.

Ideally, calculated data, especially aggregate calcs, would not be saved. Enter transaction records and calculate balance when needed. Review http://allenbrowne.com/AppInventory.html

[MdHaziq]

Thank you all for your replies.

[MdHaziq]

I would like to let users select the subsystem,item and location via cascading combo boxes and leading to ItemID in tblUpdating. Can it be done?
I also would like to display the columns in ItemIDST a new field I created to display subsystem,item, location and with val(), Total Quantity too.
But I realize that report do not have function column count. I would like to do the same thing with rptLog.