Autorefresh column

[mihmih]

Hi,

I have a table in the subform, I would like to click on this table (get focus) and make autorefresh the sql command in one of the columns (list box). How can i get it? Thanks for help.

[UnklDonald418]

A table grid control on a subform does have an event When receiving focus, so a macro could be constructed using that event to locate the list box control, then one line of the macro, something like

Code: Select all

oControl.refresh 

would force the list box query to execute.
Without more detailed information on the form it would be difficult to give anything more specific.

[mihmih]

Thanks for the answer, I will try to explain it in more detail...

So I have four tables: with contractors, with orders from contractors, with the products of the contractors and a junction table (ID, order ID, product ID). The table with the products contains the contractor's ID.

And the problem is a form with adding orders ... in this form i adds order data in the main form (the source is a table of orders), then I go to the subform (table), where i adds product data (the source is a junction table). The first column in this table is the list box, where from the drop-down list I select products from the product table (the source of this drop-down list is the product table). All I want is that this list should be limited only to the contractor that was selected from the drop-down list in the mainform on this form, where i adds order data.

[Villeroy]

[Base, Python] Tiny Macro Refreshing Forms, List/Combo Boxes

[Villeroy]

[Base, Python] Tiny Macro Refreshing Forms, List/Combo Boxes
together with viewtopic.php?f=100&t=94393 (cascading list boxes).

It would be easier if you could use a subform with a grid control instead of a list box.

[mihmih]

Thanks for the answer, but I have looked through all the forms in both databases ("movies" and "countries_city") and I do not see a similar situation to that described by me...

[F3K Total]

Hello,
i tried to create a simple sample DB. If i got you right, products and orders depend on the contractor. I used a one-row-filter-table to store the contractors ID, then a linked-order-subform to display the contractor orders and finaly another linked subsubform to display/work on the junction tables content. The listbox in the products column of the table-control is filtered by contractors ID stored in the filter table.

[mihmih]

it looks like that's what I meant. thanks a lot .... if it could be done without the "set contractor"-button it would be perfect

[Villeroy]

Well this is just another trivial example of macro free "power filtering".

If you want to maculate this solution with a macro in order to save one click:
1) Install my AutoRefresh.py
2) Call the form navigator and move the "set contractor" button to the filtering parent form.
3) set its action from "Refresh" to "Save" and its default button property to Yes. Now it reacts on the enter key and saves the stored filter criterion in the filter table.
4) Add a hidden control to the filtering form. Name it AutoRefresh and set its value to F_ORDERS (name of the subform to be refreshed).
5) Assign macro My_Macros>pyDBA>AutoRefresh>form_Action to the filtering form's event "After record action". Now the macro will be triggered after the form has been saved and it will read the name of the subform to be refreshed from the hidden control. The same macro can refresh multiple forms, subforms, parent forms or any list boxes and comboboxes in all forms on the same form document.

[mihmih]

ok, I have a question, maybe a stupid question ...

For Python macros to work, python must be installed on my computer?

[Villeroy]

It comes with your office.