need help with field refreshing

[MaXXXiMaNiAc]

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

[David Schofield]

On 23 Dec 2004 09:41:57 -0800, Ma**********@gmail.com wrote:

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

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