J
Justin26
I am trying to create a data entry form to enter records in to two different
tables. I set up two subforms and use cascading combo boxes in the subforms
with a Requery macro to limit the selections going in to these records.
The last step was to use three combo box inputs to update a text box which
would have the price of the product or service in it. This price would be
retrieved from a Product Master or Service Master table. I tried to use the
SetValue macro but repeatedly got error 2950. The odd thing is that the
SetValue macro works fine in my main form so I think it must be my syntax. I
have tried datasheet and continuous subforms.
SetValue macro expression:
nz(DMin("Charge_per_Saleable_Unit","Patient_Checkout_Filter_by_All"),"")
Filter criteria example (three of these):
[Forms]![Patient_Checkout]![Sell_Inventory].[Form]![Supplier_Name]
I am out of ideas and going in circles. Can you please help?
tables. I set up two subforms and use cascading combo boxes in the subforms
with a Requery macro to limit the selections going in to these records.
The last step was to use three combo box inputs to update a text box which
would have the price of the product or service in it. This price would be
retrieved from a Product Master or Service Master table. I tried to use the
SetValue macro but repeatedly got error 2950. The odd thing is that the
SetValue macro works fine in my main form so I think it must be my syntax. I
have tried datasheet and continuous subforms.
SetValue macro expression:
nz(DMin("Charge_per_Saleable_Unit","Patient_Checkout_Filter_by_All"),"")
Filter criteria example (three of these):
[Forms]![Patient_Checkout]![Sell_Inventory].[Form]![Supplier_Name]
I am out of ideas and going in circles. Can you please help?