Simple Linking Question (Access 2000)

[Philip]

Hey everyone,

I've got a real newbie question and I'll try to make some sense as I
explain it.

I've got a three tables for simplification.

SCREENS (screens names)
CONTROLS (control names)
SCREEN PAGES (page text)

Background Conception of DB Design: Each Screen has multiple pages, as well
as multiple controls.

I have made a Query for each table so that [qControls] & [qScreenPages] will
only return records where their [ScreenIndex] field matches the
[ScreenIndex] field in the current record of [qScreens].

When I open the queries, [qControls] or [qScreenPages] by themselves Access
prompts me for the [ScreenIndex] Value for each Query. Thats great, looking
good.

But then I made separate forms for the three Queries and 'bundled' them all
onto a new form using the Subform/subreport control. My aim is that when the
current record of [qScreens] Changes the [qControls] & [qScreenPages] Querys
will update to reflect that change.

My first thought is to look for an "AfterRecordChange Event", but I can't
conceptualize how this is going to work with out one.

-> Do I have to manually refresh these Queries whent he Active Record
changes in [qScreen]? . o 0 (please say no)
-> Am I barking up the wrong tree?
-> I would also like to add a text search that would be able to reQuery the
[qScreens] based on simple criteria which would in theory refresh the other
two Queries appropriately.

If it gets too complicated I'll just write an app in vb for the interface
but I am inclined to think that Access & VBA will be more than sufficiant
for my needs.

Any comments greatly appricated,
-Philip

[fmartinson]

I think that you are making things more complicated than they need to
be. Have you tried making a form based on all screens and then adding
a subform that pulls all controls and one that pulls all screen pages.
When making the subforms, just link them via [screenindex] (the
subform/report) wizard prompts you for a linking field... hope this
helps.