auto fill ... if exist

[rosito]

Hi all,
I have a table with examp. fields: T_nom,T_name,T_code,T_phone.....
I have a form, based this table.
I'd like to be able to enter T_code into my form and if it exists then T_name fill automatically on the form and skip to the next part of the form without prompting. If not – then position on T_name field in form and enter it.

 

[rainman89]

you can try creating a list box and looking up the not in list feature of the box

 

[ShaneMan]

Hi all,
I have a table with examp. fields: T_nom,T_name,T_code,T_phone.....
I have a form, based this table.
I'd like to be able to enter T_code into my form and if it exists then T_name fill automatically on the form and skip to the next part of the form without prompting. If not – then position on T_name field in form and enter it.

Hey Rosito,

Are you talking about doing this on a NEW RECORD or are you talking about finding T-code in the cboBox and then FINDING that record and going to it?

Shane

 

[rosito]

Shane,
I talk about NEW record..If there are so many records...I think I use a list box(combo box) is not good
I'm not sure that I'm right...

 

[neileg]

Why is a combo not good. You don't need to select the record from the drop down. If you start to type your data into a combo box, it will 'zoom' to the values you are typing. So if you type 1 it zooms to the codes begining with 1, then type 5 and it will zoom to the records beginning 15, and so on.

 

[rainman89]

zoom zoom zoom