Recent content by MLife

Hi,i have an order form which gets items from tblCD,on my sbform in order i select the items and type the quantity i want in the field "CD Quantity" ,in tblCD there is a field Quantity,and i want this field to decrease by whatever "Cd Quantity" increases by,any thoughts? Thanks

Thanks a lot :)

Hi,i have an order table with dates of orders aswell as the order info and i need to be able to view all orders within the past 7 days....any help appreciated :) thanks

Hi,ive got a form of an order and it chooses CDs from a Table,i have a field on the order form called quantity and a field on the table called quantity in stock,how do i go about decrasing the stock value when i add a value to the order? thanks

Thanks guys

I need it to calculate it for each seperate line within the record though

Hi,i have a subform where each line has (Cd ID,Cd Title.....CD Price,CD Quantity) and ive added a text box on each line to calculate the price of the line ie (Price * Quantity),how do i make it calcilate that for each seperate line as currently my sum calculates all the fields in the form rather...

Any other ideas? im sure ive done this before and created a query somewhere:o

Hi,where is the file located? The only sample database i have is the northwind one?

Hi,im trying to create an order form,i have tables of customer,cd,order and order item. Im trying to create an order form where the user selects the customerid which then creates an order number (ive done this bit) But i don't really know where to start in creating a subform for the items,i...

thanks summer,and the other dude

anyone? please?:)

Hi,ive got an order form with a subform,the subform and form are based on different tables,the subform refers to the item table,ive created a combo box to select an item and i want the rest of the details of that item to be filled in automatically.....any help appreciated thanks