How to make it autofill a cell in a table

[HotKgon]

I've attached a picture to aid me in explaining my problem.

attached picture

When making a new row, S3Score automatically has a 0 in it while P1Score doesn't. How do I make it so that P1Score also gets a 0 automatically when I'm creating a new row?

Thank you in advance!

[missinglinq]

Is P1Score a bound control or a calculated control? What type of datatype is it? How is it populated?

Welcome to TheScripts!

Linq ;0)>

[HotKgon]

Well the way it works is that I have a frame with check boxes in it. When you check a box, it'll fill it with a number. So I'm guessing that is a bound control?
You don't need to press a button for it to be calculated.

Thanks for the welcome.

[HiTechCoach]

I would recommend first looking at the table design and check to so see if the field's default value is set to 0

I've attached a picture to aid me in explaining my problem.

attached picture

When making a new row, S3Score automatically has a 0 in it while P1Score doesn't. How do I make it so that P1Score also gets a 0 automatically when I'm creating a new row?

Thank you in advance!

[missinglinq]

Which was why I asked if it was bound. Zero is normally set as the default value in a table when a numeric field is created.

Linq ;0)>

[NeoPa]

Look at the properties of the field that the control (P1Score) is bound to (I'm assuming it's a bound control for now). One of them should be the default value.

[HotKgon]

Thank you missinglinq, HiTechCoach and NeoPa for your help. I was first reading it all and I'm like... I can't get to the properties! Then I re-read HiTechCoach's post which told me to get into the design view. Only After that I understood how to change the properties and set the default value. Now it is working and it looks like my database is slowly taking shape!
Cheers all!

[missinglinq]

Glad we could help!

Linq ;0)>

[NeoPa]

Good for you HotKgon. Glad you're making progress.
BTW Where does HotKgon come from? It seems a strange kind of name.

[HotKgon]

Good for you HotKgon. Glad you're making progress.
BTW Where does HotKgon come from? It seems a strange kind of name.

Just something I thought up when I was in primary school about 10 years ago. gon for dragon, hot because dragons breathe fire and k for the first letter of my name. As you can see I was a very logical boy when I was a kid ;)

[NeoPa]

Not a typo of HotKong then (as I'd surmised)?
Logical is good. We like that here ;)