AfterUpdate Search

[Phil Heffley]

I am building a issues database for out IT dept. There are
several products that we use and I am trying to create one
single database to store and update these issues. My
primary keys are IssID and ProductID. I am trying to
create a text box that I can enter the ProductID and IssID
to find the issue that I am looking for. I have
concatenated the fields into Iss_Product&ID.

Private Sub ISS_PRODUCT_ID_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ISS_PRODUCT&ID] = " & Me!
[ISS_PRODUCT&ID]
Me.Bookmark = Me.RecordsetClone.Bookmark

This keeps erroring out with Identifier Not Recognized.

Does anyone have any ideas or know of another way to do
this?

Thanks

 

[Steve]

I would use two combo boxes. The first would look up
Productid and the second would list the issues associated
with that productid. Use the after update event of the
first combo box to requery the second combo box. Use the
after update of the issues combo box to look up your
record. That's the approach that works for me on similar
issues. The combo box helps the user make valid selections.
Good Luck