Automating data in a table field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Radhika - 23 Jan 2008 02:01 GMT

I have a table which inculde two fileds. Field 1 called "Injection" is a
Yes/No box. Field 2 called "#of Injections" is a number column. I want to
have an automated function, where if "No" is selected in "Injection", "# of
Injections" automatically fills in a value of "0". How do i do this in a
table?

Thankyou!

Reply to this Message

Tom van Stiphout - 23 Jan 2008 03:54 GMT

There is no way to do that. Reason: tables are not part of the user
interface of a normal application. Rather you would create a form,
perhaps in datasheet mode to simulate the table view, and then you can
write a single line of code in the Injection_AfterUpdate event:
If Me.Injection=False then Me.[#of Injections]=0

-Tom.

>I have a table which inculde two fileds. Field 1 called "Injection" is a
>Yes/No box. Field 2 called "#of Injections" is a number column. I want to
[quoted text clipped - 3 lines]
>
>Thankyou!

Reply to this Message

Radhika - 28 Jan 2008 21:18 GMT

I tried doing exactly that, but the code does not seem to be working.
Everytime i select 'No' in the injection box, '0' does not automatically show
up in the '# of Injections' box? What can i be doing wrong.

Thankyou!

> There is no way to do that. Reason: tables are not part of the user
> interface of a normal application. Rather you would create a form,
[quoted text clipped - 11 lines]
> >
> >Thankyou!

Reply to this Message