By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Simple Linking Question (Access 2000)

P: n/a
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

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,

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.