cynapattery
Registered User.
- Local time
- Today, 12:26
- Joined
- Jul 9, 2013
- Messages
- 28
Hi All,
I have a problem with Dlookup.
I have s search function which should select a name corresponding to ibin number and then from the bound table, populate the text boxes in the form.
this is the code I used. any body please tell me why thsi Dlookup is not giving the required output??
Var_haendler2 should have the corresponding handlername who has the ibin number entered in the text field. in the same form tehre is a bound text box Haendlername where the control will be later on and it should populate the form.
I already use in a search function and it works perfect. I do not understand why it does not work here..
please help
I have a problem with Dlookup.
I have s search function which should select a name corresponding to ibin number and then from the bound table, populate the text boxes in the form.
this is the code I used. any body please tell me why thsi Dlookup is not giving the required output??
Code:
Var_Haendler2 = DLookup("[Haendlername]", "Tbl_map_Haendler", "[IBIN]=" & Forms!frm_Trigger_Storno.txt_IBIN_Srch)
DoCmd.GoToControl "Haendlername"
DoCmd.FindRecord Var_Haendler2
Var_haendler2 should have the corresponding handlername who has the ibin number entered in the text field. in the same form tehre is a bound text box Haendlername where the control will be later on and it should populate the form.
Code:
DoCmd.GoToControl "Haendlername"
DoCmd.FindRecord Var_Haendler2
please help