Hello all,
Following on from a previous post of mine, I am wondering if the following is possible?
I have a combo box, which is set up so it lists asset numbers. The user enters the asset number, presses enter, and all that asset's details come up in the rest of the form. The asset numbers are divided into two groups, those that start with "00", and those that start with "02". Choosing which is which is easy enough, what I am having difficulty with is making the combo box put in the "00" or "02" by itself.
I know it sounds petty, but it is a lot easier if it pops these 2 characters in itself, as the users will frequently be accessing anything up to about 100 records like this every day!
I don't want to have to change the way the asset numbers are stored in my database, as this would screw up the rest of the db!
Thank you for any advice you can give in advance!!!
Following on from a previous post of mine, I am wondering if the following is possible?
I have a combo box, which is set up so it lists asset numbers. The user enters the asset number, presses enter, and all that asset's details come up in the rest of the form. The asset numbers are divided into two groups, those that start with "00", and those that start with "02". Choosing which is which is easy enough, what I am having difficulty with is making the combo box put in the "00" or "02" by itself.
I know it sounds petty, but it is a lot easier if it pops these 2 characters in itself, as the users will frequently be accessing anything up to about 100 records like this every day!
I don't want to have to change the way the asset numbers are stored in my database, as this would screw up the rest of the db!
Thank you for any advice you can give in advance!!!
