D
Don Driscoll
I have read the threads and I don't think that the suggestions I have read
will fix my issue though I could be wrong... here's the problem: Like
, I have two tables. The first contains some facility
information, the second contains activities associated with each facility. I
have designed the form and subform and things "almost" work ok... When I
select a facility from the combo box, all of the facility information on the
form changes to the correct info (good) and generally only those records
associated for that unique facility appear in the subform (good)... Now
here's the problem... When I switch facilities i.e selecting Facility #2 from
the list (via the combo box) an activity record from Facility #1 will be
placed into Facility #2. In short, what I want to have happen is that when I
enter the "activity form" I can select from a list of facilities the location
I want to modify or add records, the info about the selected facility
(address, location etc) appears in the "main" form and in the sub form the
activities associated with that Facility. Thanks for the help
will fix my issue though I could be wrong... here's the problem: Like
, I have two tables. The first contains some facility
information, the second contains activities associated with each facility. I
have designed the form and subform and things "almost" work ok... When I
select a facility from the combo box, all of the facility information on the
form changes to the correct info (good) and generally only those records
associated for that unique facility appear in the subform (good)... Now
here's the problem... When I switch facilities i.e selecting Facility #2 from
the list (via the combo box) an activity record from Facility #1 will be
placed into Facility #2. In short, what I want to have happen is that when I
enter the "activity form" I can select from a list of facilities the location
I want to modify or add records, the info about the selected facility
(address, location etc) appears in the "main" form and in the sub form the
activities associated with that Facility. Thanks for the help