query or a table?

S

short

I was just curious if this is at all possible and if so how to do it. I have
a form with many subforms, when the user clicks their choice you can view the
table(s) that go along with it.
I was wondering if it is possible to only view a few items for a table on
this form. Say there's a table with 10 items in it, and for this choice they
only need to view 4 of them, can I write code so that is the case?
OR would it be eaiser to make a query that can be updated on this form with
the four choices?
thanks
 
P

pietlinden

I was just curious if this is at all possible and if so how to do it. I have
a form with many subforms, when the user clicks their choice you can viewthe
table(s) that go along with it.
I was wondering if it is possible to only view a few items for a table on
this form. Say there's a table with 10 items in it, and for this choice they
only need to view 4 of them, can I write code so that is the case?
OR would it be eaiser to make a query that can be updated on this form with
the four choices?
thanks
Click to expand...

Giving users direct access to tables completely defeats the purpose of
the user interface (forms and reports). They should not really even
need to know about the underlying structure of the database or even
care. And giving them direct access to tables is a seriously bad
plan. You cannot do complex record level validation in Access without
a form. You can in SQL Server, but I would never want to be forced to
use a database with no forms - in my experience that has been a recipe
for disaster.

Can you filter forms and subforms in code? Sure! Not much to it.
Check out Keri Hardwick's article on Access web...
www.mvps.org/access
 
Top