LittleMan22
Technical User
Hi,
Here's some code that I have written right now:
Private Sub Form_Load()
Dim VarP As Variant
Dim VarQ As Variant
Dim VarR As Variant
VarP = DLookup("Carrier", "CurrentClientApplicationDataPolicies"
VarQ = DLookup("PolicyNumber", "CurrentClientApplicationDataPolicies"
VarR = DLookup("Amount", "CurrentClientApplicationDataPolicies"
Me.Remarks1 = VarP & ": #" & VarQ & " $" & VarR & "; "
The problem that I'm having though is that an individual can have more than 1 policy (it's a continous field) ... so how can I get DLookup to cycle through the values n + 1, n + 2, etc...
Thanks in advance,
Ryan.
Here's some code that I have written right now:
Private Sub Form_Load()
Dim VarP As Variant
Dim VarQ As Variant
Dim VarR As Variant
VarP = DLookup("Carrier", "CurrentClientApplicationDataPolicies"
VarQ = DLookup("PolicyNumber", "CurrentClientApplicationDataPolicies"
VarR = DLookup("Amount", "CurrentClientApplicationDataPolicies"
Me.Remarks1 = VarP & ": #" & VarQ & " $" & VarR & "; "
The problem that I'm having though is that an individual can have more than 1 policy (it's a continous field) ... so how can I get DLookup to cycle through the values n + 1, n + 2, etc...
Thanks in advance,
Ryan.