N
Nick via AccessMonster.com
Hi,
I am building a tool where users can manually input part numbers and
descriptions (among other things). I was given a set of design specs - the
future users want textboxes on the form that data can be entered into,
which was easy, but they also want a table into which the user can enter
data.
What I am wanting to do is create one form with a table whose field names
can change depending on what input level the user is at - i.e., if the user
is just beginning, the table will have "Part Number" and "Description",
then once those are done, the form will close, reopen, and the table will
display "Part Number", "Net Weight", and "Gross Weight".
I have a total of about 40 data fields that have been grouped into 12
categories. If I create a different form, subform, and query for each
category I will end up having to create 12 of each, whereas if I can just
change those field names I can keep it to 1 form and change the field names
12 times.
Any suggestions? I'm not even sure if programming the changes would be
easier than grinding through the 12 forms. Sorry if this isn't entirely
clear, it's been a long day
Reply with any questions and I will clarify
ASAP.
Many thanks in advance and sorry for any confusion,
Nick
I am building a tool where users can manually input part numbers and
descriptions (among other things). I was given a set of design specs - the
future users want textboxes on the form that data can be entered into,
which was easy, but they also want a table into which the user can enter
data.
What I am wanting to do is create one form with a table whose field names
can change depending on what input level the user is at - i.e., if the user
is just beginning, the table will have "Part Number" and "Description",
then once those are done, the form will close, reopen, and the table will
display "Part Number", "Net Weight", and "Gross Weight".
I have a total of about 40 data fields that have been grouped into 12
categories. If I create a different form, subform, and query for each
category I will end up having to create 12 of each, whereas if I can just
change those field names I can keep it to 1 form and change the field names
12 times.
Any suggestions? I'm not even sure if programming the changes would be
easier than grinding through the 12 forms. Sorry if this isn't entirely
clear, it's been a long day
Reply with any questions and I will clarifyASAP.
Many thanks in advance and sorry for any confusion,
Nick