Search results

Hi all. Thanks for replay. My code of Form2 for ListBox2 is: Private Sub Form_Load() ListBox2.RowSource = "Select Field21_Id,Field22 from View2 where Field11_id = " + Form1.ListBox1.Value ListBox2.Requery End Sub When I update my code of Form1 like you suggested: Private Sub...

Hi Of course my code is Private Sub cmd_Button_Click() DoCmd.OpenForm "Form2" Forms!Form2.Requery End Sub Thanks.

Hi I insert Forms!YourForm2Name.Requery in Private Sub cmd_Button_Click() DoCmd.OpenForm "Form2" Forms!YourForm2Name.Requery End Sub But it doesn't change result. Thanks.

Hi all Thanks for replay. I will specify exactly what I want to get. When user will open Form2 he/she has opened Forms1 & Form2 . Then user make new selection on Form1. In this place I have problem. User will press button to get new result, but result doesn't change. My problem is: how to...

Hi all I have a Form1 with ListBox1 where user select data and button that open Form2 with ListBox2 that will display data depends from selection. My problem is: how to open and refresh data in Form2 simultaneously? Thanks.

Hi. Thanks for response Here is my scenario. I have a 1 column listbox(class) in a form(frmClass). The listbox is populated by a Table(tblClass). It displays the TypeClass. I want to be able to get the information of the currently selected item and double-click in the listbox and automatically...

Hi ALL. I have MS Access form with 2 buttons. By click those buttons user can open other form which has ListBox. I have a problem to select item form ListBox and Add or Delete it to the table. I appreciate any help.

Calculate records per month Hi all. I need to calculate how many records I have in each month and create table based on this summary result. I appreciate any help.