Share via

DoCmd FindRecord using Null field

Anonymous
2017-04-25T14:43:29+00:00

Can, and how, do I use this on Form Load (or Button) to move to the first record where "Field1" is Null?

thank you

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-04-25T15:31:10+00:00

Can, and how, do I use this on Form Load (or Button) to move to the first record where "Field1" is Null?

I wouldn't use FindRecord for this. Instead, I'd use the statement,

Me.Recordset.FindFirst "Field1 Is Null"

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest