Form Query with Parameters

[clifftech]

I need help with a simple question... I hope...

I have form1 that uses two combo boxes to provide two input variable values for the where clause of a select query. How do I get the result of this select query to show up in a text box that is also on form1? I would like the query result, which is shown in the text box, to change whenever either of the combo box values change.

Is there an easy way to do this?

 

[Remou]

I think DLookUp should suit.

 

[clifftech]

Thanks for the info on DLookUp. Since this function is for Access 2003 is there another option for Access 2000 users?

 

[Remou]

DLookUp is available in Access 2000.