I'm building a database for a food bank to manage food drives. It has a table titled Organization Table with an auto numberprimary key, OrgID. This table contains informationabout the organization and has an one-to-many relationship toanother table which tracks events and collections.
I created three forms based on the Organization Table:
- Organization Detail form, which includes all the fields fromthe Organization Table, in form view.
- Organization Datasheet form, which includes only the OrgID and organization name, in datasheet view.
- Organization List form, which is a blank form with theOrganization Datasheet form inserted as a subform.
The Organization List form (with the datasheet view subform)is the main form that people will work with. When one clicks on the OrgID of a record in the datasheet subfor thatrecord pops up in form view … it took me forever to figure that out but itworks well now … so a record (with all its fields) can be viewed or edited withease.
In the header of the Organization List from I will put a lookupbox and some control buttons.
If a new organization needs to be added I want a button that will open a blank Organization Detail form, so the new record can be added there. Every which way I’ve tried to do this thebutton goes to a new line in the datasheet subform, I can’t figure out how tohave it open a blank detail from.
Any suggestions will be greatly appreciated!