Open Form at Specific Record Without Filter

[shenlee]

I have a combo box on a main form from which I select a ContactID. I want to open a Contact form at the record selected in the combo box. Does anyone know how I can do this without applying a filter?

 

[WayneRyan]

shenlee,

Use the BeforeUpdate event of the combo:

DoCmd.OpenForm "YourContactForm",,,"[ContactID] = " & Me.ContactID

You could even use the GetFocus or OnClick event and if the combo
has anything in it, open the form.

Wayne

 

[shenlee]

Is there a way to get rid of the filter?

Wayne,

That's how I am doing it now but it opens the form with just the one record being accessible. Do you know if there is a way I can open the form to that specific record but still have access to the other records in the table?

I have been trying to use FindFirst but I can't get it to work.

Thanks for the help!

Shenlee