Continuous Form or Datasheet Subform Setvalue



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:


Filter criteria example (three of these):


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