spiralmind
Technical User
I have a form in which I change the properties of Accounts within a database I am working on. Some of these properties are dependant upon not only which Account is selected, but also which Entity it is selected under. Because of this I have set up two listbox controls (one to select and account, another to selected an entity) so the user can specify which Account-Entity combination he/she is about to change the properties of.
I have successfully filtered the Entity box by the Account box, and created two textbox controls on the form to hold the lists' values (which seem otherwise to dissapear when the list loses focus). I am now struggling with a query-type recordsource for a third textbox control (where the appropriate property will be edited). The query, if run separately, returns a single record containing the proper field, filtered by the values of the Entity and Account value-holding textboxes, and updatable by entering a new value. For some reason, though, the textbox that should be bound to the same SQL string as this query displays a #Value error instead of an actual value. Any ideas?
I have successfully filtered the Entity box by the Account box, and created two textbox controls on the form to hold the lists' values (which seem otherwise to dissapear when the list loses focus). I am now struggling with a query-type recordsource for a third textbox control (where the appropriate property will be edited). The query, if run separately, returns a single record containing the proper field, filtered by the values of the Entity and Account value-holding textboxes, and updatable by entering a new value. For some reason, though, the textbox that should be bound to the same SQL string as this query displays a #Value error instead of an actual value. Any ideas?
