Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change Main Form control value when subform control value is modified
I need some help. I am working with an order form (frmProcessUnfilledOrders) which has an item detail subform. The subform contains a text control for "backordered quantity". I want to create a test with an IF THEN that if any item on the subform has the backordered control set to a value other...- AaronMV
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Order Main Form displays a record for each Order Detail Subform Record
I have a main form "frmProcessUnfilledOrders". This form has a subform named "qryProcessUnfilledOrders subform". In theory, I am supposed to see the main order record from the Orders table in the main form, with each item from the OrderDetails table neatly displayed below in the subform in...- AaronMV
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Delete Record Button for Subform in Datasheet View
I have an order form with a continuous subform in datasheet view. This subform displays items that are added to the order. If I right-click an item on the list, I can delete it. What I would like for my users is a "Delete Item" button that performs the same function. Any suggestions? TIA...- AaronMV
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
-
Passing Values into Order Detail Subform
I have an "Order Entry" form with an "Item Detail" Subform in datasheet view. These connect to Order and OrderDetail tables. On the Order Entry form, I have a Category combo box (cmbCategory), an Item combo box (cmbItem), a Quantity textbox (txtQuantity), and an "Add Item" button (btnAddItem)...- AaronMV
- Thread
- Replies: 13
- Forum: Microsoft: Access Forms
