M
Mrs. Ellis
Hey there,
I have a bit of a prob- I need to change a CategoryID combo box to show a
Company Name value in a report based on a table. It already does this in the
table. I'm fairly certain that this will require a DLookup function, however,
I have no clue how it works, and from the other statements that are listed in
the forum, I get either an Error! or ?Name# error in the box. Could someone
please help me construct a lookup? Here is the information.
Table: PMChecklists
Fields: PMFieldID, CategoryID, Procedure
The Category information comes from the PMCategories table with fields
CategoryID and CategoryName. The query name for the lookup field in the table
is PMCategories Query. Hope this is the right info. Thanks!
I have a bit of a prob- I need to change a CategoryID combo box to show a
Company Name value in a report based on a table. It already does this in the
table. I'm fairly certain that this will require a DLookup function, however,
I have no clue how it works, and from the other statements that are listed in
the forum, I get either an Error! or ?Name# error in the box. Could someone
please help me construct a lookup? Here is the information.
Table: PMChecklists
Fields: PMFieldID, CategoryID, Procedure
The Category information comes from the PMCategories table with fields
CategoryID and CategoryName. The query name for the lookup field in the table
is PMCategories Query. Hope this is the right info. Thanks!