Hello!

[techzenithafrica]

I am Eze Miller Sampson from Nigeria.

I am glad to join this Forum.

Thanks.

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[techzenithafrica]

Please l have a problem a problem creating a form.

I used a query to create a form with serial number from 1-10 but in the form, the numbers are scattered like numbering from 3, 5, 1...

How do I make the numbering to start from 1-10?

Thanks.

 

[theDBguy]

Hi. Welcome to AWF!

You might want to start a new thread in the Forms forum.

 

[The_Doc_Man]

Hello, Eve, and welcome.

theDBguy is correct that normally you start questions in the technical forums. This is an introductory forum for new members. But it isn't a terrible thing to ask a question in the intro message. I ASSURE you it isn't the first time that has happened. The short answer to your question is that if you want something in a particular order then use an ORDER BY clause in the underlying query that is the form's .RecordSource OR use the ORDER BY property of the form.

Form.OrderBy property (Access)

Office VBA reference topic

docs.microsoft.com

 

[oleronesoftwares]

Welcome @techzenithafrica to the best Online forum for Ms Access Developers. I am also based in Nigeria.

 

[conception_native_0123]

I am also based in Nigeria.

so am I. it's a booming area for employment I hear.

 

[NauticalGent]

Welcome abaord!