Create invoice from registration form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top