Forms Sync

[Tiago Patrício]

Hi everybody!

I'm a newbie on programing and I'm having a little dificulty on a database
I'm trying to develop on my work!

I have two forms, lets say frmA and frmB! Both are linked to two queries.
frmA is a list of names and id(index) where country = x. Then I have frmB
where I put more detail about the name which is double clicked! I've done a
macro where it opens the form first, second I've tried to Setvalue of frmBid
to the one equal to frmA! But I can't!

I'm sure there is an easy way to do such a simple thing but, being a newbie
I'm probably just doing something stupid!

Any help?

Best Regards to all

 

[Sandra Daigle]

Are you trying to go to an existing record or start a new one?

To go to an existing record you dont want to set the value of frmBid you
want to search on it - the easiest way is to use the WhereCondition
parameter of docmd.Openform.
For example, to open a form named 'frmB' on the record where the frmBid
field is equal to the frmAid on the current form
docmd.OpenForm "frmB",,,"frmBid=" & me.frmAid

 

[Guest]

try this,
assuming you want to populate text boxes in formB with
info that is in text boxes in formA.
In the formB text box's control source put
=[forms]![FormA]![text1]
where text1 is the info you wish to transfer to formB.