Create invoice from registration form

[m stroup]

I have a field called ClassID on a form. When this field is filled, I would
like to automatically create an invoice for the registration/tuition. I
thought I should create a macro in the properties of the field which opened
an invoice table. Here I could use SetValue expressions to enter the ClassId
as well as the AccountId. Would it be better to use a temporary query for
this?

 

[Steve Schapel]

M,

Generally speaking, you should never open a table. In any case, a
SetValue macro will not achieve anything with a table. If you mean you
need to create a new record in an Invoice table or some such, probably
an Append Query would be the applicable approach, and an OpenQuery
action in the macro to activate the append.