Search results

Hi folks apologies but still not got this working as I'd like. Where I'm at.. I have two subforms on my parent form. In each subform there is a calculated total. In the parent form I have two controls referencing these totals. Namely TotActivity and TotTime Where these totals are equal...

David Thanks for your help yet again. Something you said triggered it for me. The form Open property was set to open on a new Record which was causing the problem. Removing that seemed to recify the situation. Thanks Fozi

Hi David done that but gives me little more info. On opening the form it take me straight to that line. The value for the TotActivity displays if I hover over that control but nothing appears when I hover of TotTime.

This is the only code I have in the Form_Current sub. In Form_Open I have a macro to open at a new record. There is nothing in Form_Load Thanks for your help Fozi

Debug.print Me.TotActivity & vbTab & Me.TotTime If the values look the same then are they both the same data type? David I'm not sure where this line is meant to be inserted. On clicking the Debug option it takes me to the offending line with a yellow bar over it. Where do I enter this...

Thanks for the reply Ken but doesn't seem to make a difference. I keep getting a Runtime 2455 Error message saying "You entered an expression that has an invalid reference to the property Form/Report" When I debug it takes me to the line: If Me.TotActivity = Me.TotTime Then Very strange

Thanks for the reply Ken but doesn't seem to make a difference. I keep getting a Runtime 2455 Error message saying "You entered an expression that has an invalid reference to the property Form/Report" Very strange

Hi Trying to complete what I though would be a relatively simple task. Got a form with two text boxes containing values - TotActivity and TotTime. One the same form I've a Button called PrintRecord which I only want to display if both Text boxes are equal. Currently I've entered Private...

Thanks DCrake Not the first time you've bailed me out! You're a genius man.

Hey folks Still struggling with this I'm afraid. Would any of you mind if I uploaded the an example here for to look at and advise? Simply put users enter their times for each day. A calculated field works out their hours and minutes per day. I'm then trying to create a field in that form...

Tried that but to no avail i'm afraid. The control which has the formulae =Sum([Total Hrs]) is called [totall] but returns a zero value. So even when a new control set in the parent form uses it as it's control source it returns zero also.

Thanks for the response JR but that's where it is at present. Fozi

Hi folks. In a continuous subform users are entering their start times and end times per day. I have a control called [Total Hrs] that calculates the number of hours and minutes worked per day. What I want now is a control that will total all five days entries to give me a total for the week...

Thanks Rainman, that was it! In my sql statement I needed to make reference to the master form and subform which I wasn't doing. Works now! Cheers for all your help

Having a problem getting my cascading combo boxex to work when accessed as a subform within a master form. In short users pick an activity which then dictates what shows up in the subcategory control. All works fine when working directly within this subform. However when trying within the...

in the attached database I have a mock of what I'm looking to do. Two forms. One parent with subform contained. On selecting the Project Manager I want the subform to automatically populate with the associated fax and telephone number. Equally if Project Manager changes then the subform...

Hi all I have a main form containing a control called Contact. Contained within this form is a subform containing email and Telephone numbers. User pick a contact from the Combo box and I then want the subform to populate with their email and telephone details immediately. Currently they...

That what I thought so I created an unbound control in the subform and entered =Forms![FRM_Stage 1 Details]![No of Participants (ESF)] but when viewing the record it comes back with '#Name' Sorry to be a pest. Is there any chance you could amend the mock database I attached and re-post for...

Thanks again, but where do I enter the code? Fozi

Sorry I'm not sure where I would put the Me.Parent code. I've taken the liberty of attached a mock up test to explain what I'm looking to do. In the attachement there is a form with a subform. In the subform I wish to reference the parent control called "maximum participants" so as to cross...