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 GledhillOP
@Reply 19 months ago
Kevin Robertson
@Reply 19 months ago
Check the Link Master Fields and Link Child Fields properties.
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 GledhillOP
@Reply 18 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 GledhillOP
@Reply 18 months ago
Kevin Robertson
@Reply 18 months ago
Do you want the Combo Box cleared when you move to a new record, or when the button is clicked?
Stephen GledhillOP
@Reply 18 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 18 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 18 months ago
Stephen GledhillOP
@Reply 18 months ago
That's great - thanks Kevin. Learning the macro commands and correct syntax is a challenge!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 22.
