Recent content by AaronMV

Dan, Thanks much. Your code was perfect. Aaron

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

Thanks, PH. I will be less brain-dead next time.

OK, sorry for being dense. I removed the OrderDetails fields from the query that the main Order form was using as RecordSource. I then created a separate query for the subform RecordSource with the right fields, but now when the form loads, I get a parameter prompt for OrderID. If I enter a...

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

That's OK, I reformatted my subform based on your misread. The continuous form will work well for me. Thanks Again!

Remou, How can I add the button in the subform to each line/record as you suggest? I added a command button to the form in design view, but it did not appear when I ran the form.

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

The DataEntry property was set to Yes. As this is Boolean, I switched it to No to see what happens. Works like a champ now! Thanks Remou and PHV for all your help with this one. AaronMV

OK, we are on the same page now. I have verified that the Link Child and Link Master for the Subform control are both set to OrderID. Your Example is, in fact, how my form looks with the exception that I did not include the OrderID field in the subform.

Link Child, Link Master? Forgive me but I have not used these terms before. Here's what I think you are after: The subform has two rows. The ProductID row in the subform has a Control Source of the ProductID field in the OrderDetails table. The Quantity row in the subform has a Control Source...

Remou, I am not surprised that this sounds odd, as that's the story of my life! Anyway, the Order Form is named frmOrder, and the subform is named "tblOrderDetails subform" There is no additional nested subform named "tblOrderDetails subform". Is there a particular block of code I can post to...

Remou, I found the problem with the form name, it helps if I spell it right! Anyway, now that I have that right, I am able to add the item into the subform fields. My new problem is that when I go back to the Category combobox and select another Category/Item to add to the order, the subform...

Remou, Thanks for the help. I added your code to my click event for btnAddItem, but I now get an runtime error 2109: There is no field named "tblOrdersDetail Subform" This break is occuring on this line: DoCmd.GoToControl ("tblOrdersDetail Subform") This is the actual subform name...

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