This should be an easy question. I don't know why I can't figure it out. I can't figure out how to use a number in a string expression. Here's what I have which is giving me an error message:
Dim n as Integer
n = 100
Me.Recordset.FindNext "[NUMBERFIELD] = n"
(n actually gets a number from somewhere else, but it's easier to use 100 in this example).
Can anyone help me with the expression?
Dim n as Integer
n = 100
Me.Recordset.FindNext "[NUMBERFIELD] = n"
(n actually gets a number from somewhere else, but it's easier to use 100 in this example).
Can anyone help me with the expression?
