Hi All

Is there any way that when a text box is populated in a main form that it will populate a text box in a sub form with the same detail.I want the user to select a name in the main form and this will link in the ************ Male Female in the main form.But I want this also to appear in the sub form.

Thanks


Brendan Bartley

__________________
Brendan Bartley

If your form is bound to the same source as your subform, just do a requery on your subform and it should populate itself. Let me know if they are not bound to the same source and I could probably come up with something different.

HTH

Mike

Mike
EchoVue.com

No Mike the forms are not bound
Thanks
Brendan

Brendan Bartley

Alrighty Then...

Typically a subform is setup in a many to one relationship with the main form. It almost sound like in your case, you have a one to one relationship. If this is the case, your could try adding an On_Change event to the control on the main form, and then using that to change the control on the sub form.

I would think that should work.

Mike

Mike
EchoVue.com

Mike
sorry the forms are bound in a one to many relationship Mike how do I requery the sub Form
Thanks

Brendan Bartley

Hi Brendan,

To requery the subFrom, just use Me.frmSubFormName.Requery

The problem with the one to many relationship, is that I don't know of a way that you can specify which record in the subform you would like to be changed. However hopefully the requery works for you.

Mike

Mike
EchoVue.com

Mike
Sorry the code is not working I am getting the same message

Method or data not found

Thanks

Brendan Bartley

Huh!?

Sometimes Access assigns different names to controls. Check using the properties, what the name is for the Sub Form, and the various controls, and then ensure that you have the correct spelling - This one always gets me.

Mike

Mike
EchoVue.com

Mike
Tweaked the code everything ok now
Thanks

Brendan Bartley