Access will not open new form with specific data, instead it returns all - issue

[danielal]

Hi I am currently creating a database in a hierarchical system that is to be used by multiple users to enter information specific to them. The tables are arranged like this:



Owners
Modules
Tasks
Highlights

Theses are connected using primary ID’s and Particular Entries in the next table so they form a hierarchy – when you expand owners it brings up a list of Modules attached to that owner, then expand each module and it brings up a list of tasks associated with that module, expand the task and it brings up a list of highlights associated with that task. – This is all very straightforward of course but what I would like to do is create forms that basically match so that the users can navigate from their name, through their modules and tasks and then add highlights to each task.

For this I have been using continuous forms to list all the different entries and inserting a button in each entry that I would like to link to the next form and find the specific data, however when I try to do this the button always without fail will just return all the entries from the form rather than the specific ones requested. I have trawled the internet quite a bit to try and find why this is happening and have inserted various bits of code etc into the embedded macro in an attempt to make it work but to no avail.

I wonder if there is something I need to activate on the form that the button connects to aswel or if I need to connect these forms using the relationship that I used to connect the tables (I am still using a unique identifier).

If I connect to a single form it will display the first entry on the list (and I can cycle through them all) on a continuous form it will display all entries starting with the first.

I would like it to display all entries for the selected record on the form.

I hope this all makes sense – please let me know if you would like some more info. I am pretty new to Access so I’m sure this is really obvious!

Many thanks in advance!

[pbaldy]

Have you tried this one?

http://www.baldyweb.com/wherecondition.htm