I've built a database in v2007, importing various data spreadsheets from all our suppliers; it's for records and CDs. My requirement is two fold.
What i'd like to do is create a form based on information from one table - tblalldata.
I'd like to split this form into two sections:
1) - Top half of the screen, a series of search boxes ie one search box for artist, one for catalogue number
2) - Bottom half of the screen, datasheet view (but only a selected set of fields, not all - let's say Artist, Title, Format, CatalogueID, Supplier)
Suppliers, being suppliers, all do thrings differently - including names of artists. So let's take my fave band The Black Crowes, that could be listed as:
The Black Crowes
Black Crowes
Black Crowes, The
I would type in Crowes and hope for the bottom half of the screen, the datasheet view, to show all records be it listed in any of the above 3 formats.
Any help with this will be very much appreciated and if you live in the UK and can help me get this sorted, i'll throw you a free CD

David Cumming
Netdiscs
What i'd like to do is create a form based on information from one table - tblalldata.
I'd like to split this form into two sections:
1) - Top half of the screen, a series of search boxes ie one search box for artist, one for catalogue number
2) - Bottom half of the screen, datasheet view (but only a selected set of fields, not all - let's say Artist, Title, Format, CatalogueID, Supplier)
Suppliers, being suppliers, all do thrings differently - including names of artists. So let's take my fave band The Black Crowes, that could be listed as:
The Black Crowes
Black Crowes
Black Crowes, The
I would type in Crowes and hope for the bottom half of the screen, the datasheet view, to show all records be it listed in any of the above 3 formats.
Any help with this will be very much appreciated and if you live in the UK and can help me get this sorted, i'll throw you a free CD

David Cumming
Netdiscs