Later........

No one spotted my deliberate error. The Inspection table should have the
vehicle id as a foreign key and the InspectionRecord does not need the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11886-im-still-having-problems.html
vehicle id.

Rod

P.S. Ian send me your email address to fe_rod@hotmail.com and I will send
you a sample mdb for most of this.

"Accessidiot" wrote:

> I'm new to using access.
> I have created a database to help with filling a paper form system we use
> currently.
> The current paper form has about 100 entries where the user enters 1 of 5
> codes regarding checking systems on a vehicle, the codes are "ok", "Serious
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11886
> fault", "Minor Fault", "Advice Only" and "N/A".
> Buliding the database to present is fine, but I've hit 2 stumbling blocks,
> The first problem should be easy to resolve (But I can't!!) Once a vehicle's
> details have been entered, the user simply enters the registration plate
> details in a combo box and a form loads with all the details- No problem-
> This form then has a subform where the user enters combo boxes to enter one
> of the five codes. However I have to load the main form in read only to
> display the vehicle details, but then I need the subform to be in add mode.
> So is it possible to load the main form in read only and the subform in add
> mode?
>
> My second problem is taxing me. When the user checks one of 100 combo boxes
> with Serious, Minor, or advise they then need to enter a description of the
> fault and a description of the remedy. I've tried showing or hiding text
> boxes and also using a subform for each combo box, But this makes the form
> too big and cumbersome.
>
> On the original paper form there is simply a set of boxes where the user
> enters the code number for the fault, the severity of the fault and the
> descriptions.
> Is it possible for me to re create this, but with the program checking the
> combo boxes for thier value then entering the code for the fault, the
> severity of the fault and then the user can add the descriptions. I would
> prefer not to have 100 text boxes as again this makes the form cumbersome 20
> or so is plenty?
>
> Thanks for your help
> Everyone here is very helpful and certainly has a wealth of knowledge, I
> appreciate it. I'd still be at the first hurdle without your help.
>
> Ian