R
RDomico
I am an experienced .NET developer, but I don't know anything about Access.
Here is my question. I have a combo box that has a list of "projects." I
have a textbox that the user enters the number of projects. The users
selects a project from the combo box and enters the number in the text box .
Then they click the Submit button.
A "Project" is made up of parts. It could contain 2 of Part A and 3 of Part
B.
I assume I could use a subform for the next part. I want to list the parts
of the project and how many of each part that I need.
For Example.
The user selects Project Widget from the combo box. They enter 2 in the
text box because they need 2 of those Widgets. Each widget contains 2 of
Part A and 3 of Part B. Since we want 2 widgets we multiply those numbers by
2.
I want something that shows this.
Part Number Needed
Part A 4
Part B 6
I need the "Number Needed" column to be editable because for some reason
they might want to change the number that they need to pull from inventory.
Once the user is done adjusting the number, I want a button called "Pull."
From there I plan to update the inventory tables.
The part I need help with is creating the table of data. Do I use a
subform? Is there something else I should use? When I was playing with
subforms, I could not edit the "Number Needed" because it was a calculated
field. Can I unbound the "Number Needed" text box and then edit the values?
If I do, how do I access those values? Does the subform create some kind of
control array of textboxes?
In .NET I would use grid controls. What about Access?
Thanks,
Bob
Here is my question. I have a combo box that has a list of "projects." I
have a textbox that the user enters the number of projects. The users
selects a project from the combo box and enters the number in the text box .
Then they click the Submit button.
A "Project" is made up of parts. It could contain 2 of Part A and 3 of Part
B.
I assume I could use a subform for the next part. I want to list the parts
of the project and how many of each part that I need.
For Example.
The user selects Project Widget from the combo box. They enter 2 in the
text box because they need 2 of those Widgets. Each widget contains 2 of
Part A and 3 of Part B. Since we want 2 widgets we multiply those numbers by
2.
I want something that shows this.
Part Number Needed
Part A 4
Part B 6
I need the "Number Needed" column to be editable because for some reason
they might want to change the number that they need to pull from inventory.
Once the user is done adjusting the number, I want a button called "Pull."
From there I plan to update the inventory tables.
The part I need help with is creating the table of data. Do I use a
subform? Is there something else I should use? When I was playing with
subforms, I could not edit the "Number Needed" because it was a calculated
field. Can I unbound the "Number Needed" text box and then edit the values?
If I do, how do I access those values? Does the subform create some kind of
control array of textboxes?
In .NET I would use grid controls. What about Access?
Thanks,
Bob