On click textbox inserts value back on combobox

[whitelockben]

Hi all,

Thanks for your help so far my database is moving along nicely.

I have something I want to add though and this is that on click in a text box the text box will look at another value in a combobox and based on that value with insert a specific letter.

E.g. If cboT.Value = "Electical" a P would be instered into the text box.

This field will be my key field and everything will be unique however I also want the field to auto insert the next number.

It will be made up of a number prefixed by either P or IC. So I want the db to search for the number from the record previous with the same prefix and use the next number.

Does anyone know if this is possible?

 

[John Big Booty]

Perhaps this sample will give you some pointers.

Note that the prefix is only added to the raw order number for display purposes as it is a calculated field and can be easily generated when required for display.

 

[whitelockben]

Superb, thank you!