Recent content by eugewp

  1. E

    Subform - Enter the value of the parameter

    I don't need the ID actually. I need to complete some data in a table, for that a use a query (which is filtered by the ID). Whith this, i was create a form.
  2. E

    Subform - Enter the value of the parameter

    OK. It finally works... I'm sure that it isn't the rigth form to do this. How works: - I create a public function that gets the value of the id. - I use it for do the query - I put a textbox in the form with the name of que parameter of the popup and put as value the function
  3. E

    Subform - Enter the value of the parameter

    I try it, but don't works. it's the same as the first.
  4. E

    Subform - Enter the value of the parameter

    The parameter is an ID. The subform (data sheet) that i get it is in the main form. How can i pass a TempVar to a query?
  5. E

    Subform - Enter the value of the parameter

    its works but, some really strange happens. The form don't stop requerying.
  6. E

    Subform - Enter the value of the parameter

    Thanks for your quick reply. I don't know about open args. But i will try to get the parameter in the form B in some hide textbox and then call it in the query.
  7. E

    Subform - Enter the value of the parameter

    I have a query based form A , it filters by a parameter that it gets from a subform [F4_OCs] in the main form [F4_Inventario]. Until here everything works. The problem is that when using the form A as a subform in other form (B), the popup appears. The only way to open the form B is in the...
  8. E

    Solved Access subform in datasheet view changes my records when adding new

    Man, this is perfect. Thank you so much!!. How did you do that?
  9. E

    Solved Access subform in datasheet view changes my records when adding new

    Thank you very much for your help. I wait your answer
  10. E

    Solved Access subform in datasheet view changes my records when adding new

    Nice! Cantidad and Precio not change. In Nombre is another combo box, that is related to the query.
  11. E

    Solved Access subform in datasheet view changes my records when adding new

    oh, sure, I think the problem is that your access is in English and the filters that I put in the SQL are in Spanish. Im not in home rigth now, you can search and replace in the union query SQL Formularios!F4_Nueva_OC... by Forms!F4_Nueva_OC... or when i come home, i will change and send.
  12. E

    Solved Access subform in datasheet view changes my records when adding new

    I imagine that you will be directly opening the subform. The query is referred to as a subform, that is, the parent form has to be open for it to work. The F4_OCaux subform is not intended to be used independently. You have to enter the data by F4_Nueva_OC.
  13. E

    Solved Access subform in datasheet view changes my records when adding new

    the way to add records is by using the combo boxes. First the "Tipo" is selected (this launches an update event to the "Nombre" field) and then the product is chosen.
  14. E

    Solved Access subform in datasheet view changes my records when adding new

    Yes: For reply the issue you must go to the "F4_Nueva_OC" form. And then add some rows into the subform. The idea of this subform is to load an auxiliary table (OCaux) so that the products added in the new OC form can be easily observed. Then, by VBA code, each one will be inserted in its...
Top Bottom