Display specfic records by entering data in open form 1

[dmon000]

Is it possible to open a form where the first field is "serial number" and have the form display all records that have that serial number in a continuous form? It seems like it would be a "parameter form" if there is such a thing. Or is it possible with VB?

Thanks!!

 

[TheAceMan1]

How are ya dmon000 . . .

Better would be [blue]a combobox of serial numbers[/blue] on the form that filters the form according to selection.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997

 

[dmon000]

There are thousands of serial numbers. Typing in the serial number desired is a necessary part of this, I'm afraid.

 

[TheAceMan1]

Roger That dmon000 . . .

Be aware, the [blue]AutoExpand[/blue] property of a combobox can be set so you get the equivalent of find as you type in the combobox.

Other Options are an [blue]unbound textbox for serial number entry and filtering. If the performance of your db isn't too slow, you could perform filter as you type here as well! . . .

As an example of using the unbound textbox, consider the user enters the number and hits the enter key. Code in the [blue]AfterUpdate[/blue] event of the unbound textbox would be:

[blue]   Me.Filter = "[FName] = '" & Me!UnboundTextboxName & "'"
   If Not Me.FilterOn Then Me.FilterOn = True[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997