Assistance with a Form

[blueboy2001]

I'm having terrible trouble getting this damn form to work as I want it to, and I could really use some serious help.

This is my final year project for my degree and has to be completed by the end of the week. Bit last minute I know.

If anyone would be willing to help me over MSN or email, I'd be eternally grateful and I'd be happy to return the favour in any way I possibly can. My email address is me@chrisquinn.co.uk

I've attached the database to this post to make things easier (Access 2000).

The problem I'm having with the form frmjob and the 2 subforms. They almost work, but there are a couple of issues with them:

1. The select equipment subform messes up the jobid field. I want it to lift it off the txtjobid field on the main form. It does pick it up, but it then seems to move it to the next record

2. The box to select the driver on the select driver subform won't let me select a driver, even though it produces a list of names.

3. The 2 subforms need some sort of validation routine to ensure the same items cannot be selected twice

4. I need a validation routine to check that when a job is saved, the equipment and drivers are not booked out on another job overlapping the same time.

I will, of course, reference any assistance I receive and credit the work to the author

 

[Uncle Gizmo]

Well, I notice you have a many to many link between drivers and jobs. This means you can have many drivers on the job which is probably a good thing. [grin]

Your form doesn’t have any sub forms on it, only a couple of combo boxes.

I think you need to do a bit more work yourself.

 

[blueboy2001]

The concept of having many drivers on each job is an essential requirement of the system. In terms of the database, there isn't a direct many-to-many link between the two because of the tbljobdrivers table is an intermediate entity. I can't see that this is a problem?

As for their being no subforms, there should be! And I've just clocked why there isn't - I've uploaded the wrong file! That was the initial version I was messing with a couple of weeks ago.

The version I'm working on now is here: http://www.geocities.com/hexfilesuk/jnw.zip

 

[Uncle Gizmo]

>>>many drivers on the job<<<<<

this was an attempt at humor...