I asked a similar question a little while ago, and some answers made me decide to basically just start over with a different design/structure. I have a customers form, and an Orders form, with Order Detail subform. I am trying to put a button in my Customers form that when clicked, it opens the Orders form for that customer, but the Order Details subform is blank, or in Add mode. Right now I can get it to open to the current customer, but it's to the record of the first of any previous orders. How can I get it to a new order?
Currently the onclick event is an embed macro where:
Action is OpenForm
Form Name is Orders
Condition is ="[Customer ID]=" & [ID]
I can also get it to open the whole form in add mode, and then just select the customer from the dropdown list, but I'm trying to eliminate that step.
Any suggestions???
Thanks
Currently the onclick event is an embed macro where:
Action is OpenForm
Form Name is Orders
Condition is ="[Customer ID]=" & [ID]
I can also get it to open the whole form in add mode, and then just select the customer from the dropdown list, but I'm trying to eliminate that step.
Any suggestions???
Thanks