navigation problem and...

[GrizzlyHippo]

Hi

Finally got my db up and running over the last 2 months, now reviewing a few staff comments. Have had a think around the following areas, but having difficulty working things out. Any ideas on what to do or where to look for further info is greatly appreciated.

1. problems navigating from project list layout (table), to job sheet layout (form), to time billing layout (tabs). I am using job No. as the common factor ( on all 3 layouts- auto fill), and button scripts (Go to Layout) to navigate. There is a tendency for wrong job no. to occur on time sheet layout, but not project list or job sheet layouts. does anyone have any idea why this may be happening? My only thought is that it is associated with a sort associated with status of the job (button). Could this be affecting the navigation in any way?

2. Is there any way of double clicking on the project list table (e.g. field- job No.) and gaining direct access to the associated job sheet? I presently have a button set up for navigation (as described above).

3.The client report layout (table) is not allowing resizable columns to the users, only the administrator, although I have tick boxed the appropriate section in layout set up. I have also allowed modifiable access to this layout for the relevant accounts but this still doesn't allow anyone the ability to resize the columns. Is there anything else I could try ?

4. Finally On the client report I have date field in the header section. This uses the calender available to maintain input format. The date is shown in Browse, but when the report enters preview mode prior to printing there is no date in the field box, and it is not printed. I have outlined the box, and this prints out but not the date. The font for the date is black on a white background (I checked this to make sure I wasn't going mad). I have no idea where to take this as it seems a little bizarre!!

Please help.

Many Thanks