G
G2
I have a form that displays several combo boxes allowing the user to make
selections. The combo boxes then relay the selectiosn to a table called
Search that stores their values. I then run a query called results that uses
the table called Seach and links it to four other tables to display the
results I want. I then base a second form on this query. I am able to
update the records if I have the form's default view is in single form and
the Dynaset is set to inconsistent. However, if I try to change the form's
default view to Datasheet, I can no longer update the records. I tried
changing the Dynaset to inconsistent while the Default view is Datasheet, but
the output then does not display any records, which is obviously wrong. Any
help would be greatly appreciated.
selections. The combo boxes then relay the selectiosn to a table called
Search that stores their values. I then run a query called results that uses
the table called Seach and links it to four other tables to display the
results I want. I then base a second form on this query. I am able to
update the records if I have the form's default view is in single form and
the Dynaset is set to inconsistent. However, if I try to change the form's
default view to Datasheet, I can no longer update the records. I tried
changing the Dynaset to inconsistent while the Default view is Datasheet, but
the output then does not display any records, which is obviously wrong. Any
help would be greatly appreciated.