Issue with accessing and modifying unbound controllers in subform details
-
In the figure above I have highlighted in red as an unbound controller and green as bounded controller. My intention is turn all the bound controllers into unbound controller but I need to be able to get the data from the SQL query and insert them into these unbound controllers and as it adds new row, and new row and new row depending on the amount of items from the SQL.
Say for example in the database SQL query it display 10 items I want those items to be displayed in the detail header as you see in the picture by using sql queries and looping through the controllers and then inserting a new line and fill the controllers with the values from the SQL query and so on.
Thanks in advance.
- xboxown - Friday, June 22, 2018 11:39 AM
In the figure above I have highlighted in red as an unbound controller and green as bounded controller. My intention is turn all the bound controllers into unbound controller but I need to be able to get the data from the SQL query and insert them into these unbound controllers and as it adds new row, and new row and new row depending on the amount of items from the SQL.
Say for example in the database SQL query it display 10 items I want those items to be displayed in the detail header as you see in the picture by using sql queries and looping through the controllers and then inserting a new line and fill the controllers with the values from the SQL query and so on.
Thanks in advance.
You'll have to write the VBA code to do that. Unbound controls provide you the flexibility to have much greater control over the user experience, but they do impose a fair chunk of effort on your part. If you understand procedural programming and are familiar with the ADO recordset object model and the VBA language, there are plenty of helpful web pages you could find to show you what that kind of VBA code looks like. Asking someone in a help forum to "write it for you" is too large an effort on the part of a volunteer, so if push comes to shove, you may need to hire a consultant to do that work.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply