On my Form not all my database shows on the form view.

[Seth Schrock]

Define "will not check them". I'm not sure what you mean.

Did you do what I asked in my previous post?

[tswalgamuth]

I did what you wanted me to do in design form. I ran it and all records were there none missing. On my form I have check boxes we use to search for different skillsets, Area Interest and time and etc.

When I added the new contact, it would not let me check my boxes?

[tswalgamuth]

Seth it will not add my new contact either

[tswalgamuth]

Any new information to help...thanks tami

[Seth Schrock]

So your original missing contact is now shown, but when you try to add another one, it is missing now. Is this correct?

Are you still having issues with the checkboxes?

[tswalgamuth]

When I go to add a contact to my form and save it. I x out of access and go back in and when I goto my form and at the bottom where it shows Record: the new contact is not there.

Yes some of my checkboxes will not check.

Thanks

[Seth Schrock]

Are you searching for the new record with the checkbox filters?

[tswalgamuth]

This is a volunteer database for non profits for their board. So I receive a criteria and I check all that matches that criteria and search and it should give me list of volunteers that will fit that organization.

[tswalgamuth]

Seth do you have anymore ideas to help? Thanks Tami

[jforbes]

Tami,

People often underestimate the complexity of an Access database. They think something along the lines, "Well I know Excel, and I've made mail-merges in Word. Access is just another Office program... I should be able to do it." Excel and Word have a relatively slow learning curve compared to Access. In most cases people can use Excel and Word for years without ever getting into the programming language, let alone SQL queries. But this is not the case with Access. Access has Macros, but to do anything of complexity the developer (yes, developer) needs to use VBA and SQL to create the application. It takes a certain skill set, or type of person to effectively use VBA and SQL, a Developer or Programmer.

I think this problem might be beyond you and would require someone with programming experience to address. I would recommend you look around locally for some talent that can come in and help you with your database troubles.

I apologize if this sounds harsh, that is not my intention.

[tswalgamuth]

Thank you Seth for all your time.

[Seth Schrock]

Just curious, did the latest new record show up like the first one did?

[zmbd]

tswalgamuth:
Whoever setup your database didn't normalize it ((database normalization and table structures) doing you a real disservice which has resulted in this huge query and most likely the reason your record wasn't showing up and now your checkboxes not working (I suspect one of the INNER JOINS) and this will be a huge undertaking to solve, most commercial software isn't going to resolve such an issue.

I'm also going to PM you a copy of some resources that I hope you will find useful as you go forward with this... Bytes.com>InBox

Please let us know how you're progressing...