Combo and subform

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
 
P

PieterLinden via AccessMonster.com

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

If your combobox has several columns (one for each {Item, ItemDescription,
Price}) and their widths are set to zero, you can then create textboxes that
show the data.

=Me.cboItem.Column(1)
note that the index is one *LESS* than it's ordinal position. (so start
counting at zero, not one).
 
M

Mike Painter

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