C
csingram
I have a form with several tabs with subforms on each. The main form is bound
to the Client table (ClientID is the key). The subforms are bound to the
Coverage table and there is a one to many relationship between them. The key
for the Coverage table is ClientID, EffectiveDate. The subforms have
different fields from the Coverage table on each one. The linking field is
the ClientID. I have 2 issues. When I add a record to that table from the
first subform, then click on the second tab, it doesn't display the new
record. Also if I navigate to a different EffectiveDate on one subform then
click on another tab, I would like it to display the fields from the record
of that same EffectiveDate. Right now the forms are displaying the most
current date by using the Order by in the subform's properties to display
Desc. Any help will be appreciated. My VBA skills are limited.
to the Client table (ClientID is the key). The subforms are bound to the
Coverage table and there is a one to many relationship between them. The key
for the Coverage table is ClientID, EffectiveDate. The subforms have
different fields from the Coverage table on each one. The linking field is
the ClientID. I have 2 issues. When I add a record to that table from the
first subform, then click on the second tab, it doesn't display the new
record. Also if I navigate to a different EffectiveDate on one subform then
click on another tab, I would like it to display the fields from the record
of that same EffectiveDate. Right now the forms are displaying the most
current date by using the Order by in the subform's properties to display
Desc. Any help will be appreciated. My VBA skills are limited.