Forms Sync

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tiago Patrício - 03 Jan 2005 14:15 GMT

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

Reply to this Message

Sandra Daigle - 03 Jan 2005 16:28 GMT

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

Signature

Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Tiago Patr?cio wrote:

> Hi everybody!
>
[quoted text clipped - 14 lines]
>
> Best Regards to all

Reply to this Message

- 03 Jan 2005 16:33 GMT

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.

>-----Original Message-----
>Hi everybody!
[quoted text clipped - 15 lines]
>Best Regards to all
>.

Reply to this Message