Form/Sub Form

[AEROTJK]

Hello,

I have a table of vehicles that have a vehicle number associated with them
however these vehicle numbers are not unique and therefore there is no unique
key, meaning multiple records can have the same vehicle number. I would like
to make a search form with a text box on the main form that when I enter a
vehicle number, the subform becomes visible with the corresponding records.
I have tried this however only one record is displayed. Can someone educate
me on what I am doing incorrectly?

Thank you in advance.
TJ Kenfield

 

[John W. Vinson]

Hello,

I have a table of vehicles that have a vehicle number associated with them
however these vehicle numbers are not unique and therefore there is no unique
key, meaning multiple records can have the same vehicle number. I would like
to make a search form with a text box on the main form that when I enter a
vehicle number, the subform becomes visible with the corresponding records.
I have tried this however only one record is displayed. Can someone educate
me on what I am doing incorrectly?

Thank you in advance.
TJ Kenfield

The simplest way would be to make the textbox the Master Link Field of the
subform (and make it a Continuous or Datasheet subform to display multiple
records).