Search results
-
B
Store calculated field in the table
Please show me how to store/add calculate field in the table. Thank you very much. I attached the database for review. In the database, I have 3 fields, QtyReceived, QtyRemain, QtyUsed. The calculation is QtyRemain = QtyReceived - QtyUsed (where QtyUsed is in the subform and it will add total of... -
B
Get data of combo box based on table on another subform
Please help ... I have a Mainform and 2 subforms. In one of subforms, I have a combox box which I would like to get data from a table of another subform. I did select the field I want from that table but it listed everything, how to do it to get only the data base on record selected. I attached... -
B
limit number of records in subform base on a field select on MainForm
I have Main Form name MainForm and I have Sub Form named SubForm In the MainForm I have a field name Quantity and I would like when I enter Quantiy such as 3 then I just let people to enter only 3 rows in the SubForm, if I enter 1 then I just let people to enter only 1 rows in SubForm. How do...