Search box

[mikeinohio]

how can i setup a seach feature using a textbox to locate a part in a
database and then display all the related information on the same form, i
wantot be able ot do this by part number, an also how can i display when the
last time the part was sold and and to whom?

 

[Al Campagna]

Mike,
On my website, I have a sample 97 or 2003 sample file called "QuickFindCombo" which
shows how to, using a combobox, easily find any record in a recordset. And, if your
PartNos are unique, that will do the trick just fine.

Re: Last date a part was used... you should have a PartNo related table something like
PartsDisbursements with all PartNo transactions (One PartNo to Many Transactions). On
your PartNo form, a DMax function (unbound calculated field) against PartsDisbursements
should do it...
example: (use your own object names)
=DMax("[OrderDate]","tblPartsTranscations", "PartNo = " & [PartNo])

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."