Hello
I have a list box displaying some records when I open a form.when i click on a record,the record is displayed in a text box on the same form.so far it is done.Now,based on the record which I selected in the list box it has to search in my table and fetch some more records which corresponds to that and display in my other text boxes.
Could some body please help me.

Any help would be appreciated.

When you select a field in your list box, use a reference to those fields as the criteria for the subform recordsource.

It's probably easier to save the various required fields of the selected record on your form as hidden controls, then reference ths hidden fields in the criteria of the query for the recordsource for your subform.

Hello llk,

could you pls tell me how to do with a d-lookup function.

This what i want to do actually.

I have a table called risks with risk_id as a primary key field.There are so many fields in this table:risk_name and priority
being among them.I have a form designed with a list box and 2 text boxes.when i open
the form,all the risk_name's are being displayed.when i click on a
record in the list box,the risk_name is shown in one text box and i want the priority of the risk_name to be shown in the
other text box.what i am trying to do is using a d-look up function
and it is not working.could you pls help me whether d-look up function can be
implemented in this case.If so,how and where should i write the code.