Recent content by Sadukar

Thanks Roy Does not work though. When I debug and hold cursor over I get the message Form!FrmMaim!List22 <microsoft access cannot find the field 'FrmMain' refer... Any more sugestions?

Hi all, I havent messed around in access in a while and I think I am bit rusty. Anyway, I have a button that filters a list box. This is fine to do except when I have to do it from another form. For Example: Dim strDept As String Dim lst As ListBox Set lst = Form.frmMain.List22 (problem)...

My Code is for Subform_current It wont update if I put it under the filter code. Also The form ID field may be have a greater number than the filtered records. For example. If I have a filter on and the subform ID field is 40 but there are only 10 records filtered then the code will try go...

Hi all, Main form and Subform data is taken from the same table. The subform is a grid used as an index for the main form in the same window. I have a number of filters which I want to filter the subform and Main form. When I select a record in the subform, I want to go to that record in the...

Hi all, Main form and Subform data is taken from the same table. The subform is a grid used as an index for the main form in the same window. I have a number of filters which I want to filter the subform and Main form. When I select a record in the subform, I want to go to that record in the...

thanks ken works perfect.

Hi all, I want to filter a subform by a date. Can someone give me a few pointers. What I want is to filter a date in the format 01/08/03 by the month being 08. Me.subform.Form.Filter = "[Date] = '##/08/##'" Me.subform.Form.FilterOn = True Any sugestions? thanks s.

no I want form/subform set-up thanks for suggestion

Can someone tell why this is not working? On a form I have a subform, 2 text boxes and a button. One of the fields in the subform is a date field. I want to filter between 2 dates. this is the code I used for the button. Me.subform.Form.Filter = "[Date] between #" & Text36 & "#...

tried wont work. Thnaks anyway.

tried what you said. It did re-enter as a double number but the numbers went back in as the rounded off numbers. Thanks anyway.

Thanks Willir At least I know there is nothing I can do. Also sorry about the subject. Just forgot.

Thanks richard It works if I put new values in but the old values stay the same. They will not change to the value I originally put in. IE 7.5 I know they still retain those values as I tried adding up a few in reports. Any suggestions on how I can change them?

Hi all I have a table and the numbers are going in and automatically rounding off. IE: If I enter 7.5 it will round up to eight. How do i turn this off. The field properties are set to Long Integer with 2 decmil places. I have messed around a bit but cant find what is wrong. Thanks S.

thanks, Ger