Fix Order Entry System - Microsoft Access Expert 22


	Back to Access Expert 22 Comments List

Upload Images @Reply Bookmark Link Email

Fix Order Entry System

Stephen Gledhill

4 months ago

I have just fixed my own order entry system as per instructions in Expert 22 (3) and all works well. However, when I enter a new record, my OrderF main form and my CustomerSubformF are blank as expected, but the LineItem subform always remembers the previous order's products entered using the "Add Product" macro button (see screenshot).How can I stop this? If I delete them, they are deleted from the LineItemsF - not good!

	Stephen Gledhill OP @Reply 4 months ago

	Kevin Robertson @Reply 4 months ago
Check the Link Master Fields and Link Child Fields properties. Subforms

	Stephen Gledhill OP @Reply 4 months ago
Hi Kevin - Link Master Field - OrderID, Link Child Field - OrderID. I think that's as it should be isn't it? Or am I misunderstanding you?

	Stephen Gledhill OP @Reply 3 months ago
I recently "fixed" my own order entry system as per instructions in Expert 22 (3) and all works well. However, I'm struggling to find a way to clear the unbound combo box the macro button uses to copy the products to the order line items subform. The last item copied stays in the box, even when you move to a new record (see attachment). Can anyone advise?

	Stephen Gledhill OP @Reply 3 months ago

	Kevin Robertson @Reply 3 months ago
Do you want the Combo Box cleared when you move to a new record, or when the button is clicked?

	Stephen Gledhill OP @Reply 3 months ago
Ideally when the "Add Product" button is clicked (but after the macro has done all its copying to the Order Details Form of course). That would stop the last product entered carrying over a new order, and stop me adding the same product again by mistake .

	Kevin Robertson @Reply 3 months ago
In Design View, right click on the Button and click Build Event. This will open up the Macro behind that Button. Add another Set Value to the Macro (make sure you click 'Show All Actions' on the Ribbon) then move it up as shown in my screenshot below.

	Kevin Robertson @Reply 3 months ago

	Stephen Gledhill OP @Reply 3 months ago
That's great - thanks Kevin. Learning the macro commands and correct syntax is a challenge!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 22.