Access-check box - checked, if checked it opens another form?

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

I currently use Access 2000. currently do not have the option on upgrading
to the most current version.

I use the database for quality within the work place. Currently have forms
set up as non conformance, corrective actions, preventive actions, vendor
discrepancies.

I would like to take one form (called frmnon-conformance), have a check box
at the bottom of it asking the question "is a Corrective Action required?",
if yes, then it will open up another form that will need to be completed.
Having both forms connected.

Within reports, how would I have the original form and any attached form
printed?

I hope there is someone out there that might be able to guide me in the
right direction.
 
Judy said:
I currently use Access 2000. currently do not have the option on upgrading
to the most current version.

I use the database for quality within the work place. Currently have forms
set up as non conformance, corrective actions, preventive actions, vendor
discrepancies.

I would like to take one form (called frmnon-conformance), have a check box
at the bottom of it asking the question "is a Corrective Action required?",
if yes, then it will open up another form that will need to be completed.
Having both forms connected.

Within reports, how would I have the original form and any attached form
printed?

I hope there is someone out there that might be able to guide me in the
right direction.
Click to expand...

This could be one of those situations where, if you get the data/table
structure optimised, Access will do more than half the work for you.
Essentially, connect the tables correctly, and Access will connect the
forms for you.

I'd guess you have a table of non-conformances. If you have a
one-to-many relationship between NC's and Actions, you'd have a separate
table for Actions. I'm assuming you can use the same table for
Corrective and Preventative Actions if you have a field to distinguish
the type. The Actions table would have a field to store the ID (key) of
the parent NC. Use the Access Relationships window to "tell" Access
about the link. If you then use the Query Builder Wizard, you'll end up
with a query which will "join" the two tables together so you can view
related values from both tables.

If you then use the Forms Wizard to build a form based on that Query,
the Wizard will ask you if you want to use a subform or a linked form
with this data. Either way, your users could use the standard record
controls (the "VCR" controls") to add related records, with no
programming. Note the Linked Form option provides and configures just
the sort of button you are asking about. I've been using Access on and
off for over 10 years and I'm still astonished how much work it does for
you - IF YOU GET YOUR TABLES RIGHT. You could have this working in 10
minutes. (Ok, an MVP could have this working in 10 minutes - lesser
mortals do take longer...).

Note, you have to include the field which "joins" the tables so any new
Action records can be associated with the correct NC when you add a
record in the linked form. This can be automated, but that's just
beyond the scope of this answer - if you get this much working you'll
probably figure the rest out yourself.

I can't guess how you'd need to handle a vendor discrepancy. (Bawl them
out, I suppose...)

Hope that helps. If you have problems on specifics, post back. But
figure your tables out first, so you can describe them in your post.

Phil, London
 
Back
Top