Hi you guys...I'm stuck again.
While awaiting your reply to my earlier posting, I decided to go ahead & set up the next new "main" form. I am working on the first subform that goes on it...same exact principals as the first main form for the Freelancers only this one is for the Projects and may have several people working on each one. I've got my list box and the control which places the selections onto the junction table. Then I've got my combo box which is supposed to pull those selections back off of the junction table & post them back to the subform so that they can be seen & deleted if necessary. Since we're dealing with the freelancers here, I thought it best to include 3 fields in this combo box...the ID # which is the bound field, and the first & last names. At first I set the field length for column one to "0" because I don't need to see the FreelancerID #; however I was having problems so I changed it back to .5". When you click on the down arrow, you see all 3 fields (or just the 2 when I hide the first one)...but, only the first field visible field will actually post in the box (I have it wide enough so that's not the problem...which since that's usually the Last Name, it would be OK since they see the first name when they choose the arrow so know who they are choosing. The only problem is that when I try to do anything else, I get an error telling me that the Last Name field can't be left Null in the tbl_Freelancer_Information. I can't figure this out because that field is NOT null. I had the Row source as a qry at first, but changed it to an SQL statement like I did the one a few days ago because it seemed to be deleting from the Project table rather than the junction table. Now I'm not sure if it's working correctly because of this problem. I do know something isn't quite right even before this particular step because on the other form, the moment I make the selections from the listbox, they automatically post in the combo box below...and this one isn't doing that.
What am I doing wrong?
Again, I appreciate your assistance. What would I do without you guys? I am learning so much from you both, yet still feel as if I don't know anything. It's especially quite confusing having to worry about setting properties for the same subform in 2 different places...one while the subform is open in Design View and the main form is in Form View...and the other when both the main form and the subform are opened in Design View. Why is this & is there a way around it?
I patiently await...
USEN
While awaiting your reply to my earlier posting, I decided to go ahead & set up the next new "main" form. I am working on the first subform that goes on it...same exact principals as the first main form for the Freelancers only this one is for the Projects and may have several people working on each one. I've got my list box and the control which places the selections onto the junction table. Then I've got my combo box which is supposed to pull those selections back off of the junction table & post them back to the subform so that they can be seen & deleted if necessary. Since we're dealing with the freelancers here, I thought it best to include 3 fields in this combo box...the ID # which is the bound field, and the first & last names. At first I set the field length for column one to "0" because I don't need to see the FreelancerID #; however I was having problems so I changed it back to .5". When you click on the down arrow, you see all 3 fields (or just the 2 when I hide the first one)...but, only the first field visible field will actually post in the box (I have it wide enough so that's not the problem...which since that's usually the Last Name, it would be OK since they see the first name when they choose the arrow so know who they are choosing. The only problem is that when I try to do anything else, I get an error telling me that the Last Name field can't be left Null in the tbl_Freelancer_Information. I can't figure this out because that field is NOT null. I had the Row source as a qry at first, but changed it to an SQL statement like I did the one a few days ago because it seemed to be deleting from the Project table rather than the junction table. Now I'm not sure if it's working correctly because of this problem. I do know something isn't quite right even before this particular step because on the other form, the moment I make the selections from the listbox, they automatically post in the combo box below...and this one isn't doing that.
What am I doing wrong?
Again, I appreciate your assistance. What would I do without you guys? I am learning so much from you both, yet still feel as if I don't know anything. It's especially quite confusing having to worry about setting properties for the same subform in 2 different places...one while the subform is open in Design View and the main form is in Form View...and the other when both the main form and the subform are opened in Design View. Why is this & is there a way around it?
I patiently await...
USEN