Apply field value from subform to field value from another subform with condition

Apply field value from subform to field value from another subform with condition

Post by papo » Sat, 08 Nov 2003 18:17:25


Hi all
I need to retrieve a value entered in a field(a) of a subform1 and put it
into another field(a) of a subform2.
My problem resides in the fact that this depends on the values of 2 fields
from my main form ie:
If Field 1 andf Field 2 from my main form = True then field(a) in subform2
will get the value of field(a) in subform1
Else I will do nothing

How can I achieve this?
Which event should I trigger?
What syntax should I use?
Can anybody help?

Thanks in advance
Best regards
Pascal
 
 
 

1. Updating field on a form from a sum of values field on a subforms footer.

2. Form/Subform return values where field is not null

I have a form whose record source is a query and shows all construction
projects. There is a subform whose record souce is the same query showing
all bid dates. When I put a parameter for a bid date value, it requires me
to put in the date twice. I assume that is because the same query is running
both the main & subform.

If I use the table as the record source for the Main form & a query for the
record source of the subform, it returns all records instead of just the ones
with the date requested.

If I do a "or is null" type query to return all records, I only want to see
all records where the bid date field isn't null. How do I do that with all
of the above?

3. Add a value to a Table field from Subform Control

4. Update field value automatically based on subform

5. Hide Columns in a datasheet Subform based on a another field value

6. How do I populate a subform field with a value from the main form?

7. Limiting subform entries based on mainform field value

8. Text field Default value in subform

9. Subform Previous Field Values

10. Problem transferring a field value to a sub form of a subform (3 levels deep)

11. how do I get the field value from main form to subform?

12. Text box on main form won't pick up value from field on subform

13. Using calculated value in subform as field entry in main form

14. How to add values to a field in a subform

15. How do I populate a subform field with a value from the main f