Rick Stanich
King and Supreme Ruler
- Local time
- Today, 06:12
- Joined
- May 13, 2009
- Messages
- 93
Attached is a DB. It is small and has a few forms. I am using this to teach my self some DB design and programming. I have good practical experience with VB and VBA (90% Excel).
The intital DB design special thanks to jzwp22.
The form "DataImport" is finished. (jzwp22)
The form "tblJobs" is for viewing current information in reference to the last form "Form1".
Form "Form1" is my test form
In my test form, I have two sets of data I am working with.
The form has two sections:
"Manually define parameters"
and
"Selectivily define parameters"
The section "Manually define paramters" works with TextBoxes, where I am trying to link data so that:
If Part Number is 4502730 then Part Revision choices can only be the Letter Y (A single choice of two possible choices), with Part Number and Part Revision completed Job Number has to be relate to the two prior textboxes and Serial Number has to be related to all of the prior textboxes (either Data set 1 or Data set 2 dependant on the Part Number entered).
As it is now, no matter what I select in Part Number all of the remaining textboxes have all possible choices of both Data sets.
The exact same scenerio needs to be setup for the combo boxes in section "Selectivily define parameters".
Any hints, tips or examples is appreciated.
p.s.
Make ME learn, but give me a little break
The intital DB design special thanks to jzwp22.
The form "DataImport" is finished. (jzwp22)
The form "tblJobs" is for viewing current information in reference to the last form "Form1".
Form "Form1" is my test form
In my test form, I have two sets of data I am working with.
Note: tblJobs will display this information.
The form has two sections:
"Manually define parameters"
and
"Selectivily define parameters"
The section "Manually define paramters" works with TextBoxes, where I am trying to link data so that:
If Part Number is 4502730 then Part Revision choices can only be the Letter Y (A single choice of two possible choices), with Part Number and Part Revision completed Job Number has to be relate to the two prior textboxes and Serial Number has to be related to all of the prior textboxes (either Data set 1 or Data set 2 dependant on the Part Number entered).
As it is now, no matter what I select in Part Number all of the remaining textboxes have all possible choices of both Data sets.
The exact same scenerio needs to be setup for the combo boxes in section "Selectivily define parameters".
Any hints, tips or examples is appreciated.
p.s.
Make ME learn, but give me a little break
Last edited:
