Auto look up a record

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hi!
I have a form called "Sketch Sheet" with a subform
called "Colors". I am trying to auto look up a record
when a primary key is entered. I.E. The field "Style
Number" is entered. If that particular style number
already exists, I'd like it to pull up that record. I've
tried everything but it keeps just bringing up the subform
info for that record and not the entire Main form info. I
know this is probably an easy one that I'm just missing.
Thanks in advance for your help!
-Sandy
 
Sandy said:
Hi!
I have a form called "Sketch Sheet" with a subform
called "Colors". I am trying to auto look up a record
when a primary key is entered. I.E. The field "Style
Number" is entered. If that particular style number
already exists, I'd like it to pull up that record. I've
tried everything but it keeps just bringing up the subform
info for that record and not the entire Main form info. I
know this is probably an easy one that I'm just missing.
Thanks in advance for your help!
Click to expand...

Build a combo box on the main form and pick the option to find a record
based on the selection.
Just entering a key in a text box will not do what you want (but it should)
 
Back
Top