I am creating a form in Access 2007 which is in tab form format. The form has multiple tabs, each tab pertaining to a different part of the same record. I am attempting to make a tab page to include medications. Each row of the form contains 5 fields regarding each medication name 1. Medication Name, 2. Medication Dose, 3. Medication Dose Unit, 4. Medication Route, 5. Medication Frequency.
This particular page has appx 40 rows, each containing the above 5 topics. I am looking for a way to clear or delete individual rows...For example if a medication order is discontinued I want an easy way to click and have all 5 fields cleared so a new medication would be added. It would also be nice if when a row is cleared it moves data up so there are no gaps in the form.
Is there a way to do this? I am by far no expert with Access, but have been unable to find an answer in my books, or by researching online...
Any help that can be provided would be greatly appreciated!!!
Mahalo!