Hi,
I currently have form that based on a branch number (in the header), the detail pulls in a series of pog's. I'm looking for a way to use dcount to check for any duplicates. I've tried using:
..but each line only then dcounts up to one. It seems like its only comparing the value in a record against the record itself instead of the whole form. Any ideas?
I currently have form that based on a branch number (in the header), the detail pulls in a series of pog's. I'm looking for a way to use dcount to check for any duplicates. I've tried using:
Code:
=DCount("POG_ID","tbl_POG","POG_ID = '" & Forms!qry_load_branch!pog_id & "'")
..but each line only then dcounts up to one. It seems like its only comparing the value in a record against the record itself instead of the whole form. Any ideas?
Last edited: