P
Pat Pawlowski
I have been designing an access database for a clothing
store. I am working on an order form where the line item
has a 2 combo boxes for size and color. The sizes and
colors are stored in 2 tables and linked to the products
table via p_id field. The row source query of the size
combo box is: SELECT sizes.*, sizes.p_id FROM sizes WHERE
(((sizes.p_id)=forms!order.[order details]!p_id)); This
work according to plan at home where I am using Access
2002 but at work where I am using Access 2003 it doesn't.
The combo box just comes up empty. Also, the database is
saved in Access 2000 format.
TIA, -pat
store. I am working on an order form where the line item
has a 2 combo boxes for size and color. The sizes and
colors are stored in 2 tables and linked to the products
table via p_id field. The row source query of the size
combo box is: SELECT sizes.*, sizes.p_id FROM sizes WHERE
(((sizes.p_id)=forms!order.[order details]!p_id)); This
work according to plan at home where I am using Access
2002 but at work where I am using Access 2003 it doesn't.
The combo box just comes up empty. Also, the database is
saved in Access 2000 format.
TIA, -pat