Combo and Text Box Information

[xp1]

Hello,

I am trying to quickly build a form to do the following, program contains:

Table 1
Table 2

cmbUnit (combo box)
txtPart (part number)

I am getting the unit number from Table 1 as a source, which by the way works with a different form. I will select any unit number, for an example V100 and then type in the first part number in the text box (eg. 100), so I could have V100 with part numbers 100, 101, 102 and another Unit might be V200 with part numbers 201,202,203 and so on.
These records will be saved into a new table (Table 2).

My question is how do I automatically display the last part number when a value (unit number) is selected from the combo box. If I would select the V200 unit then 203 part number would be displayed somewhere (maybe list box), that way I know which part number to enter next.

Any help is much appreciated, thanks.

 

[Fifty2One]

If there is a master pattern for the numbers by type like unit V1, V2, V3 then you could have the Combo populated with the heading of the parts and then poll the same database for the maximum number of the unit field in tabel 2 with a like statement.

Hello,

I am trying to quickly build a form to do the following, program contains:

Table 1
Table 2

cmbUnit (combo box)
txtPart (part number)

I am getting the unit number from Table 1 as a source, which by the way works with a different form. I will select any unit number, for an example V100 and then type in the first part number in the text box (eg. 100), so I could have V100 with part numbers 100, 101, 102 and another Unit might be V200 with part numbers 201,202,203 and so on.
These records will be saved into a new table (Table 2).

My question is how do I automatically display the last part number when a value (unit number) is selected from the combo box. If I would select the V200 unit then 203 part number would be displayed somewhere (maybe list box), that way I know which part number to enter next.

Any help is much appreciated, thanks.