Automating Numbers

[alastair69]

Dear All,

I have spent two days looking for an answer to a problem i am having, i have a database that i need to populate room numbers, i have a front form which allows a user to enter how many rooms there are on a floor. I would like a button funtion that will count up to the maxiumum number in my text box.

So far i have a form with a text box called "NumberRooms" another text box with floor Called "Floor".

The answer i am looking for is as follows:-
Number of Rooms 2 Floor Ground Floor
G/001
G/002

I am not sure how to even start this i would like to how some ideas and ideal an example of code.

I look forward to your responces.

Alastair

 

[MStef]

Hello Alastair!

Look at "DemoAutomatingNumA2000.mdb",
Open Form1 and try.

 

[alastair69]

Thank you for the help, i am having a look now. Cheers

 

[alastair69]

Mstef,
Cheers for the help this is exactly what i need, and closes my question.

Thanks Again