Continuous Form or Datasheet Subform Setvalue

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top