1. Change the Format or the Decimal Places property of the control to display more digits.
2 & 3. If you include the Products table in the query of your form, Access will automatically lookup the weight when you set the Foreign Key. However, you must copy the values if you want them saved in the order detail record. The common technique is to include those extra columns in the Row Source of a combo box you provide to select the product. In the AfterUpdate event of the combo box, copy the values to the current row using the Column property of the combo box - Column(0) is the first column. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of farbod1981 > Sent: Saturday, July 23, 2005 2:50 AM > To: [email protected] > Subject: [ms_access] Order Entry Problem? > > > Hi, > Well i am a very begginer of access 2003, > i want to make some changes to order entry for my own simple work. > > 1. i want to add a weight column to products, the problem is with the > decimal places which aslways rounds up or down? > > 2. i want to add a sum of row weight, and a final weight sum of all > invoices. i have added a column in products table and a field in > products form but the data doensnt link correctly and the weight > column doesnt fill automaticly! > > 3. i also want to add a pack quantity by entering which, the pcs > quantity should be calculated, again i have a pack qantity field in > products table and its form but tha same problem invoke > > i DONT KNOW WHY THE FIELDS DOESN`T LINK CORRECTLY SO THE FOLLOWING > PROBLEMS OCCUR. > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
