K
Ken Ivins
I want to auto fill a field CheckNo when I create a new record with the next
check number.
I have a Table tblChecks with the check numbers (CheckNo field as a
Number-I'm modifying someone else's work), amounts etc.
I event created a query [qryCheckNum-recent] that shows the last check
number (using the "Max" total).
I tried below and got a type mismatch error
Dim intCkNum As Integer
intCkNum = DLookup ([CheckNo], "qryCheckNum-recent")
intCkNum = intCkNum + 1
Me.CheckNo = Nz(Me.CheckNo, intCkNum)
Please help me figure out what I am doing wrong. Maybe there is a better
way. Any ideas are always welcome.
Thanks,
Ken
check number.
I have a Table tblChecks with the check numbers (CheckNo field as a
Number-I'm modifying someone else's work), amounts etc.
I event created a query [qryCheckNum-recent] that shows the last check
number (using the "Max" total).
I tried below and got a type mismatch error
Dim intCkNum As Integer
intCkNum = DLookup ([CheckNo], "qryCheckNum-recent")
intCkNum = intCkNum + 1
Me.CheckNo = Nz(Me.CheckNo, intCkNum)
Please help me figure out what I am doing wrong. Maybe there is a better
way. Any ideas are always welcome.
Thanks,
Ken