Unbound form not populating

[gori1084]

Hi everyone,



I'm developing this database and I'm posting hoping that I can get some insight by more experienced Access users.

Revised yet again V2_Backup.zip

The attached requires login upon opening. Please use these credentials, tho no confidential info is in the file.

User: 556494
PW: cesar

I'm aware of some issues with the login form and I'll get to those later. At the moment I am interested in the form called SponsorsNew (the one that opens up upon logging in).
The UserRegion field is inherited from the login screen and upon selecting a sponsor from the combobox, the sponsor ID is populated in a beside field. Below you see the list box. That listbox is supposed to be populated with all counterparties (sponsors have one to many relationship with counterparties). I set up an after update event that should display only counterparties that have the sponsor ID equal to the one selected and that belong in the same UserRegion. I can't get it to work, I suspect because I'm not getting the requery function to work right.

Could you please take a look and help me out with this. I'm pretty new at Access and I could use some guidance.

[orange]

Your description is about How you have done something and how it's supposed to work.
Can you step back and tell us WHAT the data base is about? What is your "business"?
Until readers understand WHAT you are trying to do, it will be difficult to suggest HOW it could be done and the options you may have.

[ItsMe]

If the form is Unbound, the Requery method will not work.

[ranman256]

You cant requery an unbound field (or form). You can only assign values to unbound controls.... txtBox.value = "bob".

[rpeare]

Private Sub SelectSponsor_Change()
Me.Requery
'ADD THE LINE BELOW 
List14.Requery
End Sub

You have to requery the list box separately from the form. In this case your list box is named List14 so you issue a requery command to the listbox

[gori1084]

Thank you so much rpeare, that's precisely what I needed.

To those who asked what is the database about: I will respond because this is a forum about working with Access so I might as well tell you what I use it for. However, I should say that I've been asked by more senior members to keep my questions straight and to the point. I apologize if this confused someone, I tried to keep the forum line where I posted on topic.

The database is to be used as a repository for funds that my company services and it has to be multilayered. Because sponsors are in a one to many relationship with counterparties, I am constantly challenged to show them both, which means creating forms that can make navigation easier. Yes, I could use the form wizard and make bound forms if that's all there was to it but the set up and the needs require the added flexibility and customization that only unbound forms can offer.

I hope this clarifies. Sincerely, thank you all so much for reading and sharing your knowledge with me.

B