Asking too much?

[Neil Cash]

This request is probably too much for Access to handle, but I'd like to give
it a shot. I have two forms, one form (Jobs), consists of a header with
several fields followed by a body of multiple yes/no controls. The second
form, Plan Status, consists of the same header (linked to Jobs) and a
subform. Within the subform there is a combo box followed by several fields
relating to the combo box. The combo box list is the same as the yes/no
controls on the Jobs form. Is there a way, probably with Visual Basic, to
fill in the records of the subform when a user selects yes/no on the Jobs
form. And if this is possible, will both forms have to be open? If there is
a way to do this with only the Jobs form open, I'd prefer it to work that
way. Thanks in advance.

Neil Cash

 

[Rick B]

Why are you creating a duplicate record?

What not just copy the entire record to the other table if you can justify
having two records?

I think you are going about this wrong.

 

[Neil Cash]

The plan form is just an entry form for the users. All it has is yes/no
data, and each yes/no control has information that needs to be added to. So
I'm hoping that when you click on one of these controls it shows a "detailed"
record within that subform which contains information like start date, due
date, etc for the individual plan selected. It's not necessarily a duplicate
record persay.

 

[John Vinson]

This request is probably too much for Access to handle, but I'd like to give
it a shot. I have two forms, one form (Jobs), consists of a header with
several fields followed by a body of multiple yes/no controls. The second
form, Plan Status, consists of the same header (linked to Jobs) and a
subform. Within the subform there is a combo box followed by several fields
relating to the combo box. The combo box list is the same as the yes/no
controls on the Jobs form. Is there a way, probably with Visual Basic, to
fill in the records of the subform when a user selects yes/no on the Jobs
form. And if this is possible, will both forms have to be open? If there is
a way to do this with only the Jobs form open, I'd prefer it to work that
way. Thanks in advance.

Neil Cash

Well, you're writing as if you are treating the FORMS as data
repositories. Of course, they're not; a form is just a tool, a window
onto the data in your Tables. If you're trying to copy data from the
Jobs table to the Plan Status table, well... don't. If instead you
want to create a new record in the Plan Status table, you should be
able to run an Append query, probably using criteria from the Jobs
form.

Are the yes/no fields on Jobs bound to fields in a table? How do they
relate to the data in the other table?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Neil Cash]

Here's the layout. We're an engineering firm here, and we do projects on
subdivisions. And we're hoping to use Access as a project tracking database.
The jobs form is where project managers will enter in new jobs. The header
contains project number, name, manager, client, and location. Below the
header there is a list of all the possible plans involved in a subdivision.
Here project managers will check off plans that they'll need to have in the
individual project. Well, we need to track those individual plans, the jobs
form just lets you know what is required. So I want to track the plans in
the plan status form. It's an entirely different table from the jobs table
(which the form is bound to fields in a table). The Plan Status form is a
form for all plans. Users select from a combo box right now, the individual
plans, in which they can put start date, due date, approval date, and overall
progress. From there, they can then hit a command button which allows them
to view another form of the individual plan (each plan can have up to 50
elements we need to track). I'd like to eliminate the combo box, because the
users are entering the plans they need in the jobs form. And having to
select the plans again in the plan status combo box list is redundant. The
jobs form is an overall look at the entire project with 38 possible plans,
and the plan status is an individual look at the plans. That was probably
too much information, but I hope that helps.