Access Project

[Guest]

I have an access project product edit htm page and I would like to be able to
look up a product to edit without having to click through the entire list to
find the one product I need to edit. How do I create a look up to go
directly to the product from the combo box on this page? Thanks

 

[Danny J. Lesandrini]

The code will look something like this ...

' Find the record that matches the control.

Dim objRs As Object

Set objRs = Me.Recordset.Clone
objRs.FindFirst "[SiteID] = " & Nz(Me![cboFindSiteInvestigator], 0)
If Not objRs.EOF Then Me.Bookmark = objRs.Bookmark

Set objRs = nothing