VBA in access - Looping through records in a table?

Question

Ok, I have a database in access right, it is a database that monitors sales and stock for a computer store. I have a field called In_Stock in a tblItems. The primary key for this table is called Item_ID. There is a table called tblAssets that contains a field called Items and has a relationship to the Item_ID field in tblItems. I want the In_stock field to loop through each record tblassets, look into the field items, check if the field is the same as the field in tblItems - Item_ID and if it is, add one to In_Stock.


Can anyone help me?

(Sorry, that might be pretty hard to understand, but its prob the only way you can explain it lol)

Answer 1

contact cstarsoft 2000 at yahoo dot com

provide the version of access you are using... if its version 2003 he can't help

Answer 2

upload this subroutine: inner maximum Sub UpdateTA() Dim iftype As Integer Dim stfload As String iftype = [f1] stfload = [f2] If iftype = "a million" And stfload = "low" Then TA = "3.0" If iftype = "a million" And stfload = "medium" Then TA = "4.0" If iftype = "a million" And stfload = "heavy" Then TA = "4.4" end Sub Then upload this truth interior the AfterUpdate of both your mixture packing packing bins (the AfterUpdate of the textual content fabric field merely updates once you modify the textual content fabric interior the textual content fabric field itself): UpdateTA() you should also opt to operate UpdateTA() to Form_Load and the shape (i do no longer word of offhand what that's named) that takes position together as a distinct record interior the database is selected

Answer 3

email me