I have a stock type Database with some empty fields in, I would like to have a subform where I could type in the stock no. and the subform would find the record, show another field and put the ID no. in one of the empty fields.

I think it may need a query but I can't make it work, I just end up with new records

Any ideas?