Adding fields from one form to another

[Marilor]

Hi, I have two forms open... Req and Corr, what I want to do is add the values from Corr to the fields in Req, but if i have a null value it gives me an error. I'm at a total loss, any help would be appreciated.

Thanks,
Maria

 

[theprez]

It's probably giving you an error because the field in the table upon which Req is built on has a property of Required - Yes. Allow zero length - No.

Check your table design.

You have 2 choices,

1. Change the table to allow null (Allow zero length - Yes)
2. Do not add the value from Cor if it is null. Use an If statement
If not isnull(forms!Cor![the field] then
forms!Req![the field] = forms!Req![the field]
end if


There is an immediate if scenario and an NZ scenario, but lets not get too complicated here.

 

[Marilor]

Thanks

Thank you, that seemed to do the trick

Maria