Event Management Database Template

[ProCad Jen]

Hi,

I'm changing a few things on this template to make it suit the event
management we need. I have removed references to "SalesTaxRate" from the
following tables: Attendees, Registration and Company Information; I have
also removed references to same from the respective forms as well. I have
attempted to find all calculations that refer to this item and adjust them.
However, when you open the "Attendees" form, it first brings up a Request
Parameter Value box for "Registration.SalesTaxRate". Any idea where I might
have missed something?

Thanks for your help.

Jennifer

 

[Jeff Boyce]

?Checked the queries?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rob Parker]

Hi Jennifer,

The particular problem there is with the SQL statement which is the
RecordSource for the Attendees Subform. And, if you simply remove that
field from the query, you will get an error in the Sale Amount textbox on
the subform, since it is/was using that field.

You'll likely find other similar problems with other forms/subforms.

HTH,

Rob