Recent content by FoxRocks

So I have created a report for each "Item" that I mentioned above. What I hope to accomplish now is to have the corresponding report linked to the check box and then have it open when I click "Submit". I'm so deflated now that I can't use that really cool filtering idea that you gave me jdraw. :(

Oh No. I just realized how much of an idiot I am. I named some of my fields (important ones) using characters that are not part of the alphabet, so I can't use the name in VBA code because it causes errors. Stupid. So...I guess I'm back to my first idea and trying to find a solution to that...

Thanks for the link jdraw! That's a really great resource, it would definitely do the job in my case, but the format isn't what I was after...maybe it's time for me to rethink my format :)

Hello, Hopefully my title made sense, it took me a minute to try to word it properly. I've searched the internet and didn't find what I was after, although I expect this has been asked before. So what I'm trying to do is have it where in a form there are multiple check boxes that each...

Hi Galaxiom, Thanks very much for sharing, that's a really cool way to do that and it cleans up the code nicely too! ~FOX~

Hi pr2, I got something to work without using the Select Case statement. Here is what I have: Private Sub Completed1_AfterUpdate() If Me!Completed1 = "No" Then Me!NoParts1.Enabled = True Me!NoTools1.Enabled = True Me!NoTime1.Enabled = True Me!IssuedComments1.Enabled = True Else...

Hi pr2, I've edited the code exactly as you have it, however I am receiving an error: Compile error: Expected: Identifier and it highlights this part: Private Sub Completed1_AfterUpdate() Dim Is Is=Completed1.Value Select Case Is Case Is = "no" Me!NoParts1.Enabled = True...

Hi pr2, Thanks for the help! I entered the code you kindly provided into my form VBA and I received an error message saying: "Compile Error: Expected: Line number or label or statement or end of statement" I haven't tried to figure it out, I'm going to go do that now, I just thought I would...

I meant to say that what I do have now is a list box with: - Yes - No and then four controls that I want to be enabled as a result of 'No' being selected. They are: - NoParts1 - NoTools1 - NoTime1 - IssuedComments1 Thanks again.

Hi Rammundali, Thank you for the reply! I've changed the context of my requirements, meaning it's not "issued 1", etc. But the challenge is the same. Here is what I have: Select Case Completed1_AfterUpdate() Case Is = no Me!NoParts1.Enabled = True Me!NoTools1.Enabled = True Me!NoTime1.Enabled...

Hello, I was wondering if there is a way to have a certain field (or control?) become enabled based on what was selected from a list box. So what I have is a list box with: - Issued 1 - Issued 2 - Issued 3 - Issued 4 and if the "Issued 1" was selected I would like some controls to become...

Hi Rain, Thanks, I understand what you were talking about now. I've decided just to rebuild the form from scratch as I don't have a lot of time to try and solve the problem unfortunately. I will be doing regular back ups from now on! Thanks, ~FOX~

I just wanted to add that I found out the (very obvious) answer to my question about doing a back up. You mentioned the Record Source, I think that's what I'm after as well, how do I get to that? I was just doing an internet search on how to compare property sheets from two forms, but I didn't...

Thx Rainlover, but I'm embarrassed to say that I don't have a back up :( Is there any way to compare one form to another to see if something is different? I'm thinking that way I could see what property settings are different and troubleshoot it that way. Also, when doing back ups, do you just...

Hello, I have a table that I created have used to create a form. After getting the form all nicely laid out and looking good, I realized that I forgot to include a vital piece of information on my table. So I went back to my table and added it (a text box) then went to my form and added it as...