Form/Sub Form

  • Thread starter Thread starter AEROTJK
  • Start date Start date
A

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
 
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
Click to expand...

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).
 
Back
Top