mtagliaferri
Registered User.
- Local time
- Today, 18:58
- Joined
- Jul 16, 2006
- Messages
- 538
I have the below VBA code to look up a value from another table on loading the form, this works perfectly
However I need to lookup a further parameter within the same table, I amended the VBA code to
However this causes an error.
I am not familiar with VBA, any support would be appreciated.
Thanks
Code:
Private Sub Form_Load()
SalaryAnnual.DefaultValue = """" & DLookup("SalaryAnnual", "tblSalary") & """"
End Sub
However I need to lookup a further parameter within the same table, I amended the VBA code to
Code:
Private Sub Form_Load()
SalaryAnnual.DefaultValue = """" & DLookup("SalaryAnnual", "tblSalary") & """"
SalaryBasic.DefaultValue = """" & DLookup("SalaryBasic", "tblSalary") & """"
End Sub
However this causes an error.
I am not familiar with VBA, any support would be appreciated.
Thanks