L
Larry M via AccessMonster.com
Hi
I am trying to convert one of our company paper forms to an Access form to
utilize our parts database. The form would be a customer order form which
would have as a main form the customer info and a subform that pulls data
from one of our tables. The tables are rather straight forward and I have
designed several forms already that search part number info. No changes are
made via forms entry. Our parts database changes rarely. My problem is I
can not get the subform to display one row at a time from our table via a
Combo Box and text boxes similar to the Northwinds Orders form and orders
subform. What I get is my whole table displayed via the Combo Box rather
than line by line being selectable via the combo box. What am I doing wrong
here?
Thanks for any help
I am trying to convert one of our company paper forms to an Access form to
utilize our parts database. The form would be a customer order form which
would have as a main form the customer info and a subform that pulls data
from one of our tables. The tables are rather straight forward and I have
designed several forms already that search part number info. No changes are
made via forms entry. Our parts database changes rarely. My problem is I
can not get the subform to display one row at a time from our table via a
Combo Box and text boxes similar to the Northwinds Orders form and orders
subform. What I get is my whole table displayed via the Combo Box rather
than line by line being selectable via the combo box. What am I doing wrong
here?
Thanks for any help