Recent content by franc_5791

Hi All I have tried my best to sort this out and reached a point where my brain has stopped working completely. I am creating a invoicing system and there is header and line level details. Header details are on the main form and line on the subform. I have a label on the main form that...

Thanks for your response. You definitely make sense Consider the below given scenario I have 10000 order details in my table raised by 200 different sales persons Now, my Listbox will have two options or values. Sales_person and Order Id If I want all orders raised by a sales person, as you...

Hi All I am struggling with a query in my form I have a Listbox and a text box on the form. The user has select one value from the Listbox and enter a value in text box My query should be select * from mytable where variable1 (Listbox) = variable2 (text box) I am at crossroads here and...

Thanks a ton for the quick reply. I am not entirely sure with what you have said. I have a control with records found label in the sub-form footer Now, I need an if condition in the main form code to check the no of rows returned Please find attached code Thanks P

Sorry for not being clear To make it simple. I have a sub-form on the main form.There is a control on the footer of the sub-form which is the count of records returned against the query. I am trying to get this value in my VBA code of the main form I am able to access the other controls in...

Hi Ya This is ma first post. I have a form with a sub form on it. The sub form footer has a control and its value is populated at run time. This value is transferred to a control on the main form On the main form, based on the value passed, I need to write a If....Then statement block My...