Hello Paul...I'm sooooooooooooooo sorry to hear about the fires. Is there anything I can do to help those families? I have all kinds of clothing that I can donate if anyone is near my size & if I can figure out how to get it to them as I'm in Kentucky. I've been holding on to a lot of clothes ever since my sister passed away...some of hers; some of mine. I just couldn't see giving them to an organization that would just sell them for only pennies of what they were worth. Instead I've been saving them until I could find someone who would REALLY benefit from them. Please let me know of any female clothing sizes that are needed.
On the brighter side, congratulations on your daughter (where is Kazakhstan?) and on your anniversary.
The problem I'm still stuck on is still on the sfrm_Freelancer's_Skills_and_Rates. I'm not certain if the problem lies with the cmd_Store_Skills button or with the cbo_Skill_ID combo box? They both work fine as long as none of the other additional information (Other skills, Primary/Secondary rates, and/or any of the rate per boxes) have been completed. Even when I enter any of this additional information, the data IS posted to the correct table and everything appears fine until I navigate to another record and/or close the form...at which time, the data in the combo box as well as all the other boxes disappear (they are still in the table) and I can't get them back unless I delete the additional information. I've tried listing all 11 fields in the SQL with 0" on the ones that I don't need, but then I get a message saying the the # of columns don't agree (yes, I changed the 3 columns to 11). I also tried choosing one item at a time from the listbox and completing the other information before clicking on the cmd_Store_Skills button, but then I kept getting an error saying that the records can't be added because it required an entry in the RatePer table; yet, that information was being entered. I may have gotten past that problem by entering a "defualt" value for that table...not certain. I've also tried changing the SQL to get the information directly from a query that in essence provides the same informaiton. If we can't somehow get this to work on the form, I might just have to tell them they must rely on the query for this particular form. Problem is...they won't have the convenience of the delete button.
I'm fairly certain, Paul, that it's just something I'm missing somewhere. I honest tried my best to solve this on my own. I promise I did. I've also tried adding all the fields in the query to the VBA coding...but that didn't work either. I had so many things that I was trying that I kept getting confused myself.

I even somehow messed up the cmd_Store_Skills button at one point where it wouldn't post to the table at all. All the VBA coding was perfect, and the Proceedure Click was there...yet it just wouldn't work. I kept messing with it so much that it finally got to the point where Access couldn't open the main form any longer. I ended up having to go back to a backup copy of the database.
It seems as if I'm so close, yet so far from the end.

I may be learning a lot from this experience, but I sure will be glad to more on to another. I've uploaded the most recent version without any of the additinal information added. I'm sure you'll be able to duplicate the problem easily; however, I do have a backup where the form is NOT working due to the table having the information already added. If you need for me to send it to you, just let me know.
Once again, Paul, you KNOW I deeply appreciate your time. Be SURE to let me know if I can help those 6 families in any way. If not all these clothes, perhaps a financial donation? Anything...just let me know.
USEN (Karen)