Dlookup for 2 fields

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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.
 
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.
 
Sorry about that
Douglas J Steele said:
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.
Click to expand...
 
Sorry about that
Douglas J Steele said:
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.
Click to expand...
 
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).
 
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).
 
Back
Top