Auto look up a record

[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

 

[Mike Painter]

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!

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)