Hello guys!
I had to turn to a forum where people are active. First of all I have to state that I have never learnt about ACCESS, and I make my database via trying.
But now I get stuck with DlookUp. I searched forums, helps but my dlookup still comes back with #error.
I have a table with data of colleagues' jobs done. I have another table with data which I feed my form from. Here I have full names (look nice in the report) and initials (easy to type in as parameter). I would like to automatize my form (or my table) the way that the initials get in field automatically by the full names.
I have a "Data" table with the names and initials.
And the Form:
I wrote the following to the Field or argument line of the field "Initial" and I would like to store the INIT from the table "Data".
=DLookUp("[INIT]";"[Data]";"[Name]=" & [FA])
If I understand Dlookup well: The "Initial" field in the "Tasks" form will be fed with the "INIT" from the table "Data" which is in the same record as the "Name" and stored in the same form as "FA".
So If I choose Wilbur Smith from the combo box in the "FA" field of my "Tasks" form I expect "WS" there. Unfortunately I see #error :-(
I tried this too, but as I read somewhere if the field is in the same form the rest is not necessary to be written.
=DLookUp("[INIT]";"[Data]";"[Name]=" & [Forms]![Tasks]![FA])
My main goal is to feed the "Tasks" table with the initials. I tried to put this equation to the "Initial" filed of my "Tasks" table too, but did not work at all. If anybody know a better solution...