Check Box - if checked sends specific text to next field

[Guest]

Let me start off with - I'm not a programmer - I'm a person that has been
using access for years (the backend tables and queries and reports and such)
and has never had to try to design a user interface.

I'm trying now to get through creating a user interface for my boss so he
can access my database easily - total non-tech person.

I have a database table (EmpGenInfo) where i'm trying to maintain
consistency of data entered in specific fields. My fields are:

Checkbox: CIPempCert
Text Box: CIPCertTtle
Text Box: CIPCertExp (Date field)
Text Box: CIPCertNo

So, what i want to do is have boss click the checkbox and have the
CIPCertTtle filled in (Text would be say: Title Name and Grade Level) for him
so all he has to do is complete the CIPCertExp (date) and then CIPCertNo.

Any help would be appreciated - i've racked my brains and look like the
commercial right about now of this is your brain and this is your brain on
drugs!

 

[Tom Ellison]

Dear Ynnot:

"This is your brain on database." I like it!

I presume that, when the CIPempCert checkbox is checked, some employee
record is already selected.

Is there a variable text for "Title Name and Grade Level" which must be
obtained to show in the CIPCertTtle Text Box? From where does that come?

In any case, the Click event of the check box would be the place to put the
code that assigns that to the text box.

Your brain is not on "newsgroup". I hope you will find that to be an
improvement.

Tom Ellison

 

[Guest]

oh my gosh! reading your reply made it all so clear. What i need to do is
start a table with the Title Cert and Grade Classification in it, set up the
relationship and then reference that when the check box is selected in the
true onclick event...

many thanks for the response....maybe now my brain won't go to total mush -
at least for the time being...

..

 

[Tom Ellison]

Dear Ynnot:

I meant to say "Your brain is now on newsgroup." That was a typo. Hope you
didn't misunderstand it as some kind of insult!

Your grasp of the situation sounds like it may now be right on.

Can you believe it. I just typed, "Your grasp of the situation sounds like
it may not be right on." I must be having a problem with now/not today!
That's a pretty big thing, as it seems to be changing a simple statement of
fact into an insult every time!

Anyway, your response, "your reply made it all so clear" is a very high
complement. At least you're not saying anything to which I would take
offense.

I'm glad if it helped!!!

Tom Ellison

 

[Guest]

No offense taken....i as well have been having difficulties with words these
days...i believe it is from trying so hard to do what comes so easy to many.

again, many thanks for the assitance...i'm now off to try and get this to
work..