Clearing rows in a form...having trouble...Please help!!

[nurseman21]

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!

[janders468]

If your form is bound to the underlying data then any deletions made in the table will be reflected in the form. There shouldn't be any gaps. It sounds like you're talking about removing the contents of a row without actually removing the row, I can't think of any good reason to have an entirely blank row. If you have questions about how to delete rows from a table let me know and I can help you with that.

[NeoPa]

You don't say what the overall record pertains to.

If, as you say, the overall form deals with a single record across various tabs (or pages) then the only way to remove a line would surely be to delete the record upon which the line is based.

This would then remove it from all tabs of course.

If you simply want to remove the items pertaining to a single tab, then it makes no logical sense to display the lines without the items which are simply set to blank. That would just be wrong.

[kartikss]

Select the row as same as you select in excel and press delete button it will be deleted