If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Some Requerys work, some don't
Some of my combo box requerys work and some don't. I have a form
"PeopleDetails" that contains all the people. In this form there are check boxes that link with queries that include these people in differant lists. For instance, if you check the box that they are a singer than that person will be included in singer's list and won't show up in the other lists. Within my main form there is multiple combo boxes on differant subforms that allow you to pick the appropriate person from the list. I can edit or add new people to the list by pressing a button on my main form and opening the "PeopleDetails" form as a dialog box. In my code on the next line I just put a requery command to refresh all the lists that can be effected. The problem is that most of them work perfectly and a couple don't -- and I don't understand why. The following is the code attached to the "Add Person" button on my Main form: DoCmd.OpenForm "PeopleDetails", , , , , acDialog Me.Call.Form.GivenBy.Requery Me.Teaching_Detail.Form.Teacher.Requery Me.Pro_Detail.Form.GivenBy.Requery Me.Pro_Detail.Form.GivenTo.Requery Me.Other_Sharing_Detail.Form.PersonWhoShared.Reque ry Me.Audio_Recording1.Form.AudioTransferTechnician.R equery Me.SongsDetail.Form.LeadSinger.Requery All of these work. Whan I try to add another they won't work. One combobox is on a subform in datasheet view. one is a subform on a subform. One is just a subform. I have checked names and spellings and they seem correct. Any suggestions? Jared. |
#2
|
|||
|
|||
Some Requerys work, some don't
Forget that question. I just found a space between the words in the name of
the form control name. If only I could answer my own question before I spend a day troubleshooting... sigh, Jared. |
#3
|
|||
|
|||
Some Requerys work, some don't
Hi Jared,
when you say they don't work, what exactly do you mean? All of them? some of them? do you get any error message? before you open another form, it is a good idea to test the current record to see if it needs to be saved and, if so save it if me.dirty then me.dirty = false Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.accessmvp.com/Strive4Peace/Index.htm * (: have an awesome day * freedomverse wrote: Some of my combo box requerys work and some don't. I have a form "PeopleDetails" that contains all the people. In this form there are check boxes that link with queries that include these people in differant lists. For instance, if you check the box that they are a singer than that person will be included in singer's list and won't show up in the other lists. Within my main form there is multiple combo boxes on differant subforms that allow you to pick the appropriate person from the list. I can edit or add new people to the list by pressing a button on my main form and opening the "PeopleDetails" form as a dialog box. In my code on the next line I just put a requery command to refresh all the lists that can be effected. The problem is that most of them work perfectly and a couple don't -- and I don't understand why. The following is the code attached to the "Add Person" button on my Main form: DoCmd.OpenForm "PeopleDetails", , , , , acDialog Me.Call.Form.GivenBy.Requery Me.Teaching_Detail.Form.Teacher.Requery Me.Pro_Detail.Form.GivenBy.Requery Me.Pro_Detail.Form.GivenTo.Requery Me.Other_Sharing_Detail.Form.PersonWhoShared.Reque ry Me.Audio_Recording1.Form.AudioTransferTechnician.R equery Me.SongsDetail.Form.LeadSinger.Requery All of these work. Whan I try to add another they won't work. One combobox is on a subform in datasheet view. one is a subform on a subform. One is just a subform. I have checked names and spellings and they seem correct. Any suggestions? Jared. |
Thread Tools | |
Display Modes | |
|
|