Delete an Entry in a form

  • Thread starter Thread starter Steve Walker
  • Start date Start date
S

Steve Walker

Access 2000. I have created a form on which I have a subform. The main form
has students details and a combobox that selects a certain pathway for a
student. 4 comboboxes are queried which gives subjects in a group for the
pathway.

As a subject is selected I have created a setvalue to move the record to the
subform. I have created another macro that checks that a subject is not full
e.g. too many in a class. If it is a message box appears from a different
macro.

If I move to the next group/subject option the record is updated. However, I
want to delete the entry is updated because the course is full. Thought
about a delete query after update but leaves the form with a deleted error
in the text box(s).

Is it possible to delete a record before it gets updated. In my case once
the message box appears to say that the class is full.

Any links or ideas would be appreciated.

Steve
 
You say that you "move the record to the subform." I take it that this is
when the record is added to the class. Why not check the count before you do
this? You may want to try the VBA DCount function to check the number in the
class first.
 
Back
Top