Locate a Record within a Data Entry Form

[legalhustler]

I have a data entry form that displays one record at a time, I want to create a search box on top of it where I can type the ID number (which is the primary key and set to autonumber) and it will show that record. Can some help?

TIA

 

[alansidman]

This video will show you how to make that happen

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

 

[legalhustler]

This video will show you how to make that happen

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

Thanks for the helpful video. My dropdown combobox shows all unique ID #'s but when I select a ID # (in Form view) it doesn't populate the ID record information. In the Record source of my Form I put the following criteria for the ID field:

Like [forms]![Procurement Log Form].[myselector] & "*"

Note that intellisense did not popup the name of my combobox (myselector), I manually entered it. I don't know why it did not popup my combobox name. I think the issue is with that.

 

[legalhustler]

The property of the Data Entry form in the Data tab for Data Entry is set to "Yes". That is to say only one form displays. There is navigation buttons at the bottom of the form and when it is clicked it opens the data entry form as blank sheet where another entry is to be entered. When a record is entered and saved it gets posted to the Table. This begs the question, is it even possible to retrieve the saved form if I create the combobox to begin with?

 

[legalhustler]

I resolved this issue. I changed Data Entry to "No" and am now able to filter from the drop down combobox. Even then the intellisense did not show the name of my combobox, nevertheless it still works. For understanding purposes, why doesn't the combobox filter a record when Data Entry is set to "Yes" for my form?