Prevent Duplication in Sub Form

[Jamaluddin]

Hi All...



Please refer the attached pic. Its a form to create the fee voucher and issue to student. The same form is used when student submit his fee.

My question is that how I control the details section or sub form section so that the user only enters the fee head only once for each fee voucher. For example, for each voucher, the Course Fee enters once, the Admission Fee (if required) enters once.

Here, the student details are in one table (tblStudents), the Voucher details is in separate table (tblVoucher) and the Fee Details are in separate table (tblFeeDetails).

tblStudents contains the GRNO-PK, CRNo, Name, FatherName, DOB etc.
tblVoucher contains the VoucherID-PK, FeePeriod, IssueDate, SubmitDate etc.
tblFeeDetails contains the FeeDescription and Amount only.

[June7]

Don't understand. What is 'fee head'? Are you trying to prevent duplicate Course Fee or Admission Fee entries?

Is the Description a combobox?

[Jamaluddin]

Fee heads are something like Description in Billing Invoices. For example, "Monthly Fee", "Library Fee", "Computer Lab Charges", "Admission Fee" etc. If user creates a new voucher, the user select the Monthly Fee or Library Fee or any fee only once from the drop down list and when he select the monthly fee again from the list by mistake or by force, a msgbox displayed with warning that the entry all ready exist.

[Jamaluddin]

Don't understand. What is 'fee head'? Are you trying to prevent duplicate Course Fee or Admission Fee entries?

Is the Description a combobox?

Yes the description is a combo box.

[June7]

Okay. You can either make the selected items unavailable in the RowSource as soon as selected or alert the user as to the error. I have seen code for this but never applied.

Google: access vba combobox rowsource remove selected item

You should get a lot of hits. Here is one http://www.access-programmers.co.uk/...ght=combo+list

Review this for the warning approach http://bytes.com/topic/access/answer...uplicate-value

Depending on approach, code could be in the BeforeUpdate or AfterUpdate event of the combobox.

Another suggestion I ran across is at this thread http://www.access-programmers.co.uk/...d.php?t=188807