C
Christopher Cormier
This question is probably something really simple, but I
am not too familiar with Access 2k. So far all of my
efforts are in vein. Any help or even a shot-in-the-dark
guess would be greatly appreciated.
I have a form with several combo boxes that have table
values for their source. One of these combo boxes is
called 'CountyID'. 'CountyID' points to a
table 'Counties' with the corresponding value 'County'.
The form also has two subforms, one of which comes before
the combo box on the form. My problem is unless I have a
value in the combo box 'CountyID' I cannot enter data in
the subforms. When I click the subform I get the
error "The Microsoft Jet database engine cannot find a
record in the table 'Counties' with the matching field
(s) 'CountyID'" I have tried to set a default value to
the combo box, but I don't think it is being applied.
Again, any thoughts are greatly appreciated. Thanks in
advance.
Chris
am not too familiar with Access 2k. So far all of my
efforts are in vein. Any help or even a shot-in-the-dark
guess would be greatly appreciated.
I have a form with several combo boxes that have table
values for their source. One of these combo boxes is
called 'CountyID'. 'CountyID' points to a
table 'Counties' with the corresponding value 'County'.
The form also has two subforms, one of which comes before
the combo box on the form. My problem is unless I have a
value in the combo box 'CountyID' I cannot enter data in
the subforms. When I click the subform I get the
error "The Microsoft Jet database engine cannot find a
record in the table 'Counties' with the matching field
(s) 'CountyID'" I have tried to set a default value to
the combo box, but I don't think it is being applied.
Again, any thoughts are greatly appreciated. Thanks in
advance.
Chris