form to form

[Walmondo]

my many form is called sales and my one form is called inventory. after I
enter a value in my many table field called ProductCode how can I get the
related field in the inventory form ProductCode to show up-

 

[Walmondo]

Never mind on this-when I got it to work it wasn't what I wanted.The forms
are now bound so I can't freely move around in the now connected forms.