Hi!
I seem to have some very empty spaces in my head.
Could you help me fill them?
Dim intNumber As Integer
'Get value from field in table that is text
intNumber = DMax("[KeyNo]", "tblInvoiceDetails") + 1
'Fill KeyNo-field as the user enters the field
Me!KeyNo = intNumber
So what I'm trying to do is having a number be produced
as the user enters the field in subform.
Now, the number is already there, say: 100020041234567890,
and I want it to increase by one everytime I enter the KeyNo-field
in the subform.
However...I keep getting: "Type mismatch" - RunTime Error 6
What's wrong?