Combo and subform

  • Thread starter Thread starter Revned
  • Start date Start date
R

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
 
Revned said:
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
Click to expand...

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.
 
Back
Top