Keep Updating on the First Record??!!

[alexkong2003]

I don't know is it a stupid question or not... I really don hav any idea how to do it...

I just need to do an input of always update the data in same record...

For example, while i open my form then they will always showing the first record and able to update it but not creating a new record in the table...

Any help will be greatly appreciated.

 

[boblarson]

Set the form's Allow Additions property to NO

 

[alexkong2003]

Thanks Bob~ Hope that you may also able to solve my critical problem on the following thread~ Cause i can't go further without solving the problem...

http://www.access-programmers.co.uk/forums/showthread.php?t=136310

Million THANKS!

 

[ajetrumpet]

Alex,

take a look at post #14 in this thread. If you can follow what PDX means by his post, you might have a solution to your problem.

 

[boblarson]

Thanks Bob~ Hope that you may also able to solve my critical problem on the following thread~ Cause i can't go further without solving the problem...

http://www.access-programmers.co.uk/forums/showthread.php?t=136310

Million THANKS!

How many numbers could there be in the initial seed? Is there only going to be 4 to start with (example: 1234) or could there be more (123456, etc.)?

 

[alexkong2003]

Thank for the Link ... I just made some change of my Mixing number... Actually i could use my number as a 'text' data type instead of 'number' data type, because i don use it to any of the calculation. So it would be something like text orientation... is it much more easier to figure it out instead of 'number' data type???

 

[alexkong2003]

Ops i miss the message of bob~ sorry ...

Actually my concept is user could only input 4 digit from 0000 to 9999...