Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Numbering Records on a Form
That worked beautifully. Thank you so much PH.- ioshee
- Post #14
- Forum: Microsoft: Access Other topics
-
Numbering Records on a Form
PHV, Do you mean instead of: =DCount("Key",[Forms].[Form4].RecordSource,"Key<=" & [txtKey]) I would use: =DCount('Key',[Forms].[Form4].RecordSource,'Key<=' & [txtKey]) ? That didn't seem to work. I am still getting #Error? in my txtKey control. Thank you though.- ioshee
- Post #12
- Forum: Microsoft: Access Other topics
-
Numbering Records on a Form
CautionMP: your method worked great for me in a test, but I can't get it to work with my application. It seems that the difference is that my "key" field is type:text instead of a type:number. It is a unique field in the query. Any thoughts?- ioshee
- Post #10
- Forum: Microsoft: Access Other topics
