Question how do other field(s) in my record comes up

[brodaman]

I want other fields in my records automatically comes up for example A record consist of account no,Name,year of entry ,contribution and contribution date how do my search using account no brings up name and year of entry before I will then insert contribution and contribution date rather entering everything. i.e when inserting data after using the accountno to search my record then constant fields in the record should come up authomatically.

Thanks

 

[jdraw]

Please show us your table design and a few of your existing records.
If you have records in a table that already have:

AccountNumber
AccountHolderName
etc

You may get some ideas from this free video by Steve Bishop about keyword search. The video may be a good reference even if it isn't exactly what you are looking for.