i have a access main form named "salesinvoice" with this data field "invoiceno","barcode", "description","qty","price".
when i enter barcode no on "barcode' field other all details will appear automatically, now if i cannot find barcode on product (physically) of course i want search in search form by description,price or model.
to search when cursor on "barcode" field if i press f12 key search form will open, till this everything ok.
now my doubts is ..
if i search by description in search form sometime i can find more then one record , i want select proper barcode from search form rows by arrow key and if i enter from that cursor selected field barcode no should paste on "salesinvoice" form "barcode" field
how i can do this ?
please
alex