Question Database Coordinator/IT Analysis

[Mrkeith]

Greeting friends,

I'm trying to open a memo or comments box in access 2007 to add information into after clicking a check box from form view. Also when clicking this check box I need to open a memo box per record.

Can anyone help me?

Thanks

 

[GinaWhipp]

Do you have a field set up already to hold these comments?

 

[Mrkeith]

Yes! I have several different comments fields for each check box you click on for a comment or note.

 

[GinaWhipp]

Okay, good! Now need to create a form for those comments fields and you can do something like...

DoCmd.OpenForm "YourFormName"

...on the event of the Checkbox you want to handle the opening of the comments form.

 

[Mrkeith]

okay, I'll try using this script. I'm not a programmer or coder. But I'll give it a try.

Thanks so much Gina for your help.

 

[GinaWhipp]

Well, if you tell us the form name we can write it out for you to copy/paste. Beleive me it's easy as the line above just put in your form name.

 

[Mrkeith]

Yes, Thank you. The form name is called Ratio Notes.

 

[Mrkeith]

Also Gina, when I setup the script to open the form. I notice that it gives you for example: 14 more records. How can i only bring over just one record per customer?

 

[GinaWhipp]

Umm, there is only one note field? I got the impression there were several. In the meantime, in the After_Update of the checkbox put...

DoCmd.OpenForm "Ratio Notes"

Now since that will open the form a question... Do you only want it to open if the Checkbox is TRUE?

 

[Mrkeith]

There are several notes fields for each check box. The script work, it open a form to type in comments or notes and yes i only want it to open when it is true. Also i can't remember how to shrink the form box to a smaller size and not to screen size.

 

[GinaWhipp]

What is the name of the Checkbox? As long as you are not using Tabbed forms you can just resize in Design Mode and set AutoSize to No. If using Tabbed forms then you have a problem...

 

[Mrkeith]

The Check box name is Check110. The label name is Ratio Notes.

 

[GinaWhipp]

Then use...

If Me.Check110 = True Then
    DoCmd.OpenForm "Ratio Notes"
Else
   DoCmd.CancelEvent
End if

 

[Mrkeith]

This is great!. This works. Now what about the other issue. The size of the form box. Where do I go to shrink the form?

 

[Mrkeith]

Gina, This is great. But I have one other final question for you. I also need to have when you hover over the check box highlight what's in the comments box if true.

Can you help me with that?

 

[GinaWhipp]

First are you using Tabbed Documents?

 

[Mrkeith]

I'm sorry, explain tabbed documents?

 

[GinaWhipp]

Are there tabs at the top of the forms or are they in their only window? Hmmm, what version of Access are you using?

 

[Mrkeith]

Ok, now i gotcha. The form is in their window. No tabs at the top. I'm using Access 2007.

 

[GinaWhipp]

Okay then open the form in Design View, set it to the size you want and make sure in the Properties window for the form you set AutoSize to No.