A2k: data entry subform for records that don't exist

  • Thread starter Thread starter lfaherty
  • Start date Start date
L

lfaherty

Hi Access friends.

I'm looking for suggestions on the proper way to build
data entry functionality for both existing and non-
existing records. I expect I'm going about it the wrong
way.

The table fields I'm working with are:
jobName, jobPhase, jobTask, spentHours, spentDollars.
There will always be...
1)the same 5 jobTasks for each jobName/jobPhase
2)only one spentHours & spentDollars entry for each
jobName/jobPhase/jobTask

My main form displays a bound combobox (jobName), an
unbound combobox (jobPhase), and five labels that
correspond to each jobTask (1ENG, 2CONS, 3PUBS, 4Other, &
5ODC).

Adjecent to the jobTask labels, my subform displays rows
of two bound textboxes (spentHours & spentDollars) and is
ordered by jobTask. jobName & jobPhase are used as the
Link Master/Child fields.

Problem is that this only works for existing records; my
subform is reduced to a single new record row when there
are no records corresponding to selected values in the
main form. How do I make it so that the subform displays
empty rows for records that don't exist yet?
 
lfaherty said:
I'm looking for suggestions on the proper way to build
data entry functionality for both existing and non-
existing records. I expect I'm going about it the wrong
way.

The table fields I'm working with are:
jobName, jobPhase, jobTask, spentHours, spentDollars.
There will always be...
1)the same 5 jobTasks for each jobName/jobPhase
2)only one spentHours & spentDollars entry for each
jobName/jobPhase/jobTask

My main form displays a bound combobox (jobName), an
unbound combobox (jobPhase), and five labels that
correspond to each jobTask (1ENG, 2CONS, 3PUBS, 4Other, &
5ODC).
Click to expand...

Before going on with the form please describe your table structure. It
seems you would have 2 tables, Jobs and Tasks, related 1:n, but I'm
not sure I understood it all correctly. Also, it seems you have a
lookup table for job phases?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
Back
Top