Not sure if DLookup is what I need, Please advise

[Mekinnik via AccessMonster.com]

I have a form right now named just named "test" (for testing purposes only)
with two combo boxes named cboReviewBy and cboReview, I have the first combo
box populated with four field names from a table named tblHazinventory and
the second combo box populated with data from the choice made within
cboReviewBy combo box. The problem I have is I am unable to view (in a
datasheet view) the selection from combo box cboReview. The final goal of
this search form as I call it is to have the cboReview selection populate
another form to view the information and I would like it to be a read only
form. Any assistance with this code would be helpful

Thank you very much

 

[Ron2005]

Possible solution:

1) create a new form that contains perhaps a sub form that is based on
a query that contains a criteria of the second combobox

2) in the afterupdate of at least the second combo, if both combo boxes
have values then have it docmd.openform "new review form"

Ron