I have a main form with a subform for which the number of weeks field is filled in each time with the same amount as each new record is added.

I have created an unbound text box called weeks where the user will enter a figure, I would then like to be able to add this figure to the new record created on the subform.

I have tried using an on current event on the sub form:

dim vName as Variant
vName = Me.weeks
Forms!Sales_Subform!Number_of_Weeks = vName

It doesn't seem to work - any ideas

Many thanks

Taraj

If you are on the SUBform's On Current event, then you need

Me.Number_of_Weeks = Me.Parent.Weeks

If Weeks is on the main form and Number_of_Weeks is on the subform.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Many thanks for your help - worked first time !

TaraJ