Felt i subform = felt i hoved form

Hej

Ja det kan det godt

Private Sub feltnavn_Enter()

Me.feltnavn = me.feltnavn med data

End sub

Lars

not sure what the purpsoe of this is Tony, if we assume that a sub form can contain more than one record then why would you want to change the value on the main form each time it gets changed in a sub record?

OOps that wasnt an answer just a question

this is what I was looking for.
http://access.mvps.org/access/forms/frm0031.htm

and that was an answer

HI

At.: Lars, jeg kan ikke burge en macro, feltet skal udfyldes automatisk, når hoved er blevet udfyldt.


I have to connect head with sub form, but i dont have 2 fields
to connect.( no fiedls are the same)

So i when I enter data in a field in the head form, i want the same data in the a hidden filed in the sub form ?


Regards

Tony

sounds like bad database design to me

How many records are on the sub form?

If there is no relationship between data on main form and data on sub form how do you show the correct data to show on sub form when you move to another record on main form?

Yes you are right


How many records are on the sub form? It depends from 1 to 10?

If there is no relationship between data on main form and data on sub form how do you show the correct data to show on sub form when you move to another record on main form?

Yes that is my problem, when we fill in head form and sub forms, they have to be connected. They are already connected on the date, but there are more than one head forms one each day.


Regards

Tony

Not sure I understand.
"They are already connected on the date, but there are more than one head forms one each day."

If you have only one main record for each day then you should be able to use the date as the realtionship. Just ensure that the date field on the main form/tabel is unique and that it only contains a date not a time, otherwise it will never be unique.


But I suggest you look at youyr table relationships. Uzse the ID column from main form/table as relationship.

http://office.microsoft.com/en-us/access-help/guide-to-table-relationships-HA010120534.aspx

This might be of help too
http://www.youtube.com/watch?v=YZKN_-P6wck

HI Terry


I found the answer in the youtube link you send.


Tks

Tony

great, and thanks for the points