help!!! how to go to a specific record

[KulasCage]

Help, anyone

I have an unbound form with unbound textbox, how will i capture/retrieve a data from a certain table by going into specific record which i need to put on my unbound textbox?

ex.
i want to get the data from the field "file number" of table "Case" , wherein the field "caseID" = 5 and put the value on my unbound form?


I'm really depressed, i try to look for some tutorials but i can't find the solution....please help

thanks.
Kulas

 

[bjackson]

use the dlookup function

in your text box control source

=dlookup("[filrnumber]","[case]","[caseid]=" & 5)

 

[KulasCage]

hello bjackson!!!!

yehey, it works .... i'm learning here.... would u mind if i pm you if i will going to have another problem?


thanks a lot...good day.

Kulas

 

[bjackson]

no i dont mind,but bear in mind i am not an expert
just a person who has belted his head against a wall
for 3 years trying to learn access.you will find a lot more
knowlable people than me using these forums and
will get a good result if you post your questions there

regards bjackson