Question about Microsoft Office Standard for PC
I have made a Form in Access 2000 which has Main Form & Sub Form. Main Form has (Header File) and Sub-Form has (Detailed File). Relationship between the primary key field of Header Table and Detailed Table is established with Casecade Update Related Fields and Casecade Delete Related Records. I want that whenever User entered all the inputs in Header file, he must enter necessary records in Detailed file also & if he fails to do so, an alert message is appear to ensure the same & focus is set to controls of sub-form. The main form (against Header File) has following fields: 1. Issued To: (Combo box, which has Departments name, to whom, material issues). 2. Issue Slip No. (Numeric Primary key field, which has relation to Sub-Form also). 3. Issue Slip Date 4. Remarks (if any) My main form name is : Issue Main Form My Subform name is : Issue SubForm Subform has following fields : ItemID & Quantity issued Now, please let me know to set focus on controls of sub-form, how we can write the syntex & at which event whether in main form or sub-form. The sub-form (against Detail File) has following fields: 1. ItemID (Combo box, parts from part master table which are in stock i.e. (Total Receipt ? Total Issues). 2. Quantity Issued (which has following SQL to run in the event of After Update). UPDATE Item SET Item.IssueQty = NZ(DSum("[Quantity]","Issue_Dtl","[ItemId]=" & [ItemId]),0); 3. Issue Slip No. (Hidden)
Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!
Posted on May 05, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Sep 23, 2012 | Systemax Venture PC Desktop
Apr 28, 2011 | Televison & Video
Dec 18, 2010 | Microsoft Computers & Internet
Apr 06, 2010 | Computers & Internet
Apr 15, 2009 | Computers & Internet
Apr 08, 2009 | Microsoft Office Access 2003 (077-02871)...
Jan 16, 2009 | Microsoft Computers & Internet
Jul 21, 2008 | Computers & Internet
445 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: