Access (Can you fix my mess)

[chris lovett]

Hi,

First of all i hate access but i need to use this for my course. and i have had to make a very basic access database which has spiralled out of control and is now more complicated that i intended.

 

The basic specification for the task is: Create an access database which will help the IT staff at your business to manage there jobs easier.

 

The parts in red are a summary of what i've previously written incase my more in depth explanation is me talking rubbish.

 

My Issue:

I have implemented the Create email tool too my database which will send information to a seperate table to my main table.

 

So i have 2 tables. Main and sub. (Sub filled in by email)

 

I Have also created a form to show all tasks in my main Table. In this form i want to be able to view and edit my Sub Table. I attempted to add a subform which worked. But the view is not very pleasing to the eye and you view all records instead of one at a time.

 

I have 2 forms. Main and Sub. I want to be able to view the records of the sub in the main form.

 

What i have done is designed a more pleasing look and copied and pasted only the design into the main form. Then linked the control source too a hidden subform of the sub table.

 

Added new fields and linked it too a hidden subform of the subtable.

Hope your still with me.

 

This works fine for the first Record in my sub form. But i am unable to scroll through the rest of the records in the sub form. as any button i add controls the main form.

 

if i add a button to control the new fields it controls the main forms instead of my new fields.

 

Hope this makes sense. if possible to avoid relationships i would greatly appreciate it as i have managed to work around these for my access life. And intend to venture there when i have more time and a big book telling me how.

 

Thanks for any respomses in advance.

 

Chris

[chris lovett]

Don't worry about responding i've changed the design