Recent content by shawda

THIS IS POSSIBLE!! but thanks for all your suggestions.... After trying lots of different things i found that a simple subform requery did the job, [Forms]![Frm_Main1].[Form]![Rpt_StockLevel].Requery [Forms]![Main Form].[Form]![Subform].Requery After adding this to the save record button on...

I can assure you it is a report, I created the report as normal and simply clicked and dragged it into the main form, and if you go into the forms design view and click on it, it says "Selection type: Report", if you open the .mdb i posted earlier and try to open frm_main1 it comes back saying...

when i open the main form it updates fine, but when i add or update a record using one of the other sub forms i want the report to update and show the change in available stock, basicaly a running total of what is available. here's a screen shot

sorry, have converted to .mdb

I have a small database for keeping a track of what IT equipment we have in stock, The main form (Frm_Main1) contains 3 subforms, one for checking equipment in (Frm_Check in), another subform for updating records when equipment is sent out (Frm_CheckOut) and finally I have a report that shows...