On 23 Dec 2004 09:41:57 -0800,
MaXXXiMaNiAc@gmail.com wrote:
[color=blue]
>Hey all, I have attached here a sample of what im trying to do.
>
>Basically i set up a combo box in a subform where an employee will
>select his name. I want the selection to be made only once because that
>same person will be entering data for a prolonged period of time.
>
>I set up a linkchildfield on the main form to write to the main table.
>
>My problem is. on a new record, the name from the combo box does not
>populate in the linkchildfield on the main form, and a selection in the
>combo box has to be made to send the dara over....
>
>Can someone lend me a precious hand?
>
>THank you very much, any help is much appreciated!
>DB
>
http://www.zaiderman.com/db4new.zip
>[/color]
Hi
I don't thinkthe master/child properties are designed for quite this
situation.
I think you should set the default value of the field in the main form
to
=[Child1].[Form]![Combo0]
where Child1 is the controlname of the subform.
Not sure whether you also want to allow the main form field to be
updated also from this combo box.
David
