Search results

Ok I see, but how would I create a custom function. Can you be a little more specific.

I entered this iff statement and it says expression you entered is to complex can someone give me advice on how to approach this. Do you think i should split the formula Thank you IIf([MarkUpI]=100 And [Stock/NonStock1]="Stock",[QTY1]+[UnitPrice1]*1.22, IIf([MarkUpI]=101 And...

Hello, I did what you told me to do but, it brings out an error when I click continue(F5) it says invalid use of Me keyword then it highlights Private Sub Form_Current Private Sub Form_Current() If Me.NewRecord Then [BoxNo] = Nz(DMax("BoxNo ", "ARCHIVE RECORDS LIST"), 0) + 1 End Sub

Hello I have a database with data already entered. I have a Table that has a Field Name BoxNo which is also is my ID. The boxNo goes from 1,2,3,4...and stops at 50 has a gap and then starts again at 100,101..etc I want to be able to have an increment of one with the boxNo. I made this code with...