By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

OpenForm where record number >

reginaldmerritt
100+
P: 201
How does one open a form with a where condition that states to only open the form where the record number is larger than 20.

something like this i guess but don't know the correct syntax for the where condidtion.

docmd.openform "formname", acnormal, , "record number > 20"

thanks any help would be great
Jun 4 '07 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,366
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "formname", acNormal, , "[record number] > 20"
If you have spaces in the name of an object you need to enclose it in [ brackets ]
Jun 4 '07 #2

reginaldmerritt
100+
P: 201
I'll give it a try, but i thought i had tried that before, hope it works this time.
Thanks

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "formname", acNormal, , "[record number] > 20"
If you have spaces in the name of an object you need to enclose it in [ brackets ]
Jun 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.