Using Dlookup

[Khushalay]

Dear Friends

i use Dlookup to pull values from one DB into another and its working good apart from being slow.
Now I want to pull values based on two fields. Is it possible? Could you please guide me.

Thanks in advance

 

[Minty]

Use an update query, or probably better still, link the table from the other db, and create a query with a join so you aren't storing the data twice.

 

[Khushalay]

Table from the 1st Db is linked and the event is working on AfterUpdate.

Just wanted to pull data base don two fields instead of one. Possible?

 

[Minty]

Yes. Post up the current code and the name of the extra field(s) you want, and the table and fields you want to update. Indicate if they are text numeric or date fields.

 

[Khushalay]

I got it right by trial and error method.

Thanks Minty anyways
Much appreciated.