Working with Textboxes and or Comboboxes

[Rick_Stanich]

Attached is a DB. It is small and has a few forms. I am using this to teach myself 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.

Data set 1:
Part Number 4502730
Part Revision Y
Job Number 32225-1
Serial Number 090062 and or 090408

Data set 2:
Part Number 4506667
Part Revision C
Job Number 33557-1S1
Serial Number 090428

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".

I usually ask for Hints, tips or examples. I could really use some code examples this time. I am struggling to understand some of the syntax for Access VBA.

Cross posted at:
http://www.access-programmers.co.uk/...d.php?t=182566