Access form set up

  • Thread starter Thread starter Jwil
  • Start date Start date
You don't need anything very complicated to sum the costs. However, you say
you've normalized the tables... but I don't know your current table structure.
What tables do you have? Where are these costs stored: as multiple records in
a table (probably a good idea), or as multiple fields in a record (possibly ok
but probably not ideal)? What are the Recordsources of your form and subform,
and what is the subform's Master/Child Link Field? Just what do you want to
sum? You say "the three cost fields" but I don't know what those are.
Click to expand...
Hi John,

I went ahead and just used a form and a subform. I found a pretty good
tutorial from the forum on how to set it up to carry the calculations from
the subform over onto the main form and everything works perfectly.

I have a totally unrelated new project that I would like help on. I know I
should just post a new question in the forum but I'm sure I'll have a rough
time explaining it. Especially with my "excel lingo". I have a Project table.
From that table I've created two forms. One to input the data about the
project and another to create a Cover Sheet based on some of the data. I
need one more form. This one is a "traveler" that lists the tasks and
travels with the job so that the tech can fill in dates and checks and other
stuff. The problem is that there are two types of "travelers". A REDUCED form
that has about 50 tasks and a FULL form that has about 80 or so. I would
like maybe a macro or something that would create either the reduced form or
the full form based on two different buttons or something similar. I'm
thinking I could just create the "Full" one and then if they pick the
"reduced" button I could have a macro just clear the extra lines. It would
be nice though to go back and forth in case they changed their mind. Can you
get me going on this?

Thank you
 
Back
Top