Display of Data

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

I have 3 tables. GrantsTbl, LkUpAgency, LkUpFacility.
The GrantsTbl has 2 fields AgencyCode which comes from
LkUpAgency and the other is Facility which has been
filtered by the Agency chosen and comes from
LkUpFacility. Each facility has a Region associated with
it. My problem is on a data entry form I want to choose
the Agency, then the Facility, but have the Region of that
Facility appear on the form, but not have to choose it. I
am not having any success. Any thoughts?
 
-----Original Message-----
I have 3 tables. GrantsTbl, LkUpAgency, LkUpFacility.
The GrantsTbl has 2 fields AgencyCode which comes from
LkUpAgency and the other is Facility which has been
filtered by the Agency chosen and comes from
LkUpFacility. Each facility has a Region associated with
it. My problem is on a data entry form I want to choose
the Agency, then the Facility, but have the Region of that
Facility appear on the form, but not have to choose it. I
am not having any success. Any thoughts?
.
Never mind. I was able to find the answer in another
Click to expand...
section of the newsgroup. For anyone wanting the answer
here it is:

Takes two controls actually. Use a two column ComboBox
with the description in
a zero-width second column and then use a TextBox with a
ControlSource of...
=ComboBoxName.Column(1)
 
Back
Top