I am a beginner in VBA. I am developing an Order entry system for my company using the Access Order Entry Template. The Problem is I have certain groups of customers who can only buy certain products at certain prices. I have created a pricing structure table and I have Assigned each customer a certian product price list.

I want to create a VBA that will automatically look at the customers Assigned product price list and then find the proper products and corrosponding pricing thats available for that customer.

I am looking for a fairly detailed Syntax for this event.
Would you recommend a before update Event?
Would be a IIf Then or If Else?

I really have no Idea.

It sounds like you want to create Customer Groups, and then make each customer a member of a group, and then find a product list and pricing based on group membership.

This is not a coding issue, but a table design and normalization issue.

You would have to create:

tblGroup
GroupID - PK
Group Description

tblCustomer
PK
LName
FName
GroupID - FK

tblProduct
ProductID
Product Description
Price

tblProd_Group
ID
ProductID - FK
GroupID - FK
GroupPrice

Once you create something like this, the code is a little easier.

Does this look like it will work for you? Questions, Comments?

HTH to get started. Code later.

mmcdonal

Thank you! I will try to structure the tables better! I will keep you updated on my progress.