Enter info in a frame and have other frames return info

[Guest]

I simply would like to enter info (such as a customer number) into a frame
which would in turn return info about the customer in adjacent frames

 

[Larry Linson]

I simply would like to enter info (such
as a customer number) into a frame
which would in turn return info about
the customer in adjacent frames

Perhaps the reason I am not understanding your question is that "frame"
(other than Bound and Unbound Object Frame Controls, into which you would be
unlikely to enter text) is not an Access term, nor is "adjacent frame."
Could you clarify both?

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Larry,
Thank you for responding. I have 3 fields that I would like my dispatcher
to work with. EquipNum, Description, and location (we have heavy equip that
is being moved around all the time which we are trying to track) all in a
table called Master equip list. I would like to develope a form with three
object frames (I believe these are bound) that would allow the dispatcher to
enter the equip number and have the discription and current location
automatically come up. The idea would be once this info comes up, she would
use a list box to choose the new location. I have already developed a
seperate table called location for this list box. Thank you for your help
with this. I believe that this should be easy to accomplish. I have
recently attended a seminar so I am some what up to speed.