Andre Bruin
New member
- Local time
- Yesterday, 20:30
- Joined
- Apr 22, 2016
- Messages
- 8
Hi,
on a form, I've 800 textfields which are filled with data via a dlookup in VBA.
Because, it's a little bit slow, I want to use another way to fill this fields with data from a table.
See below for the DLookup function what I have at the moment.
code:
Me(k1) = ELookup("[KLant]", "[Planning_tbl02]", "[Plek#]=" & p & " AND [datum]='" & Me(k4) & "'" & " AND [bezet_ochtend]='" & "bezet" & "'")
So it's a DLookup function with 3 criteria's
Please, can somebody help me?
thanks in advance,
rg,
André
on a form, I've 800 textfields which are filled with data via a dlookup in VBA.
Because, it's a little bit slow, I want to use another way to fill this fields with data from a table.
See below for the DLookup function what I have at the moment.
code:
Me(k1) = ELookup("[KLant]", "[Planning_tbl02]", "[Plek#]=" & p & " AND [datum]='" & Me(k4) & "'" & " AND [bezet_ochtend]='" & "bezet" & "'")
So it's a DLookup function with 3 criteria's
Please, can somebody help me?
thanks in advance,
rg,
André