Combo and subform

[Revned]

hello,

is there anyway i can populate item no to Item Column, item description to
Item Description, price to Price column in my subform under main form and
leave the column Quantity as blank so i can manually enters data to it.. my
subform are bound for a query..

one more thing i bound my subform in a select query but i can not edit nor
make data entry...

pls. i appreciate for your time thanks in advcance

 

[Mike Painter]

hello,

is there anyway i can populate item no to Item Column, item
description to Item Description, price to Price column in my subform
under main form and leave the column Quantity as blank so i can
manually enters data to it.. my subform are bound for a query..

one more thing i bound my subform in a select query but i can not
edit nor make data entry...

pls. i appreciate for your time thanks in advcance

The table containing the quantity should only contain the key for the item
number and that subform built on a query joining the Item table and the line
item table.
There is no need to populate anything else, except possible the price at teh
time of teh sale.