The form automatically fills in when value entered in one field

[laruajo]

The way my form is set up now, it is bases off a query that prompts the user for a SO Num. If the number exists the form opens displays the first record with that SO Num and they can flip through all other records with that number. If the SO Num does not exist the form opens blank and they can fill in the data. However I do not like this set up. Is there any way that the form can just open normal and the user can enter the SO Num they want directly into the SO Num field on the form, if the number exists the form fills in with the first record with that SO Num and they can flip through the others, if it does not exist, the form remains blank and they can fill it in???

Thanks

 

[shannonp]

OK, although I wouldn't advise it, I'm not saying you can't do it. When you alter information within a bound field you are actually changing that information in its underlying table...bascially you may get bananas instead of apples.

Using an unbound field and a bit of nifty code to handle searching for 'SO Num' would be much more convenient and safe. You could hide 'SO Num' so you don't see double.

 

[laruajo]

I am interested in your solution, could you supply me with a little more info?? Thanks.