Access Project

P

Par3

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
 
D

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
 
Top