Link to home
Start Free TrialLog in
Avatar of maximyshka
maximyshka

asked on

Help with VBA Code in Access 2000, on change event

Please see attached database.  Please open form "Loan Officers".  
You will see information on the left and on the right side.
Left side reflect officer information from the table.

Right side reflects "Officer Information Adjustment Section"

Purpose of this section:

User can select "Officer Name" in the Officer Information Adjustment Section.  

Based on the selected value" in the Officer Name, other values in the officer Information Adjustment Section should be programmatically retrieved from  the table "AFS Code" and new (retrieved values) should be written to the Officer Table.

Current status of the work

I tried to put code to the "on change" event

Me.txtadjinitials = DLookup("[RM Init]", "[AFS Code]", "[RM Name] = " & Forms![LoanOfficers]!txtadjofname)

Current Error: Syntax Error "3075" Some issue with comma. Please help
sample-database.mdb
SOLUTION
Avatar of stathisx
stathisx
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maximyshka
maximyshka

ASKER

Thanks a lot guys.  Both answers are great. I need to double check before closing question.