Dlookup for 2 fields

[Tom]

Hi all,

This post is related to my previous post from 5\22\06 "A Challenge".

If I will create a table with all the combinations, how can I create a
Dlookup function that will find the right one and will populate the grade
field.

Is Dlookup is the right function?

I will be grateful for any input about this.

Thanks,
Tom

 

[Douglas J Steele]

Don't expect people to go searching for previous posts. Give sufficient
information so that the post stands alone, or else put this question in the
original thread.

 

[Douglas J Steele]

Don't expect people to go searching for previous posts. Give sufficient
information so that the post stands alone, or else put this question in the
original thread.

 

[Tom]

Sorry about that

Don't expect people to go searching for previous posts. Give sufficient
information so that the post stands alone, or else put this question in
the
original thread.

 

[Tom]

Sorry about that

Don't expect people to go searching for previous posts. Give sufficient
information so that the post stands alone, or else put this question in
the
original thread.

 

[Pieter Wijnen]

However,
You can use a Recordset to retrieve the combination

Pieter

 

[Pieter Wijnen]

However,
You can use a Recordset to retrieve the combination

Pieter

 

[Ron2006]

Since the grade is already associated with the two items you mentioned,
it could simply be a part of that second query that you are doing for
the second combo box.

Then all you have to do is add code to the afterupdate event of the
combobox to do the following

me.gradefieldnameonform = me.combobox2.column(2)

The columns are numbered relative to 0 so the third field in the query
is referenced as column(2).

 

[Ron2006]

Since the grade is already associated with the two items you mentioned,
it could simply be a part of that second query that you are doing for
the second combo box.

Then all you have to do is add code to the afterupdate event of the
combobox to do the following

me.gradefieldnameonform = me.combobox2.column(2)

The columns are numbered relative to 0 so the third field in the query
is referenced as column(2).

 

[Tom]

Thank you all.

 

[Tom]

Thank you all.