Recent content by nndkol

I have 2 tables – “Allotment” & “Release”( both have auto-numbered Primary key as AllotmentID & ReleaseID). The table “Release” has a field with AllotmentID such that every entry in the table “Release” is connected to the table “Allotment. For each AllotmentID there may be many ReleaseID. I have...

I need to update multiple records having same F1, F2, F3 & F4

I am new to MS Access & I know almost nothing about vba. ... I hv a table name F with fields F1, F2, F3, F4, F5 where 1st three are number fields & last two are text fields. In a form with textboxes: txtF1, txtF2, txtF3, txtF4, txtF5 and command button cmdUpdate, I want to update F5 in table F...