Go to another form

[liborp]

Hi there!
I'm quite new in Access and I faceing this problem. I have two tables A and B with relationship one-to-one. I would like to create button and put it on form of table A which has onClick event some trigger that open form of table B but with relevant record. I mean A.id = B.id. How can do that? How can I find out id (or other column) of actual record on form?
Shall I use macro expression or code?
Could anybody help me?

 

[pbaldy]

Sounds like you want this type of thing:

http://www.baldyweb.com/wherecondition.htm

 

[liborp]

Thank you pbaldy it is exactly what I need.
But now I have probably simmilar problem. Same situation realionship one-to-one ( tables User and UserDetails). I have form, whichhas some field from User and some from UserDetails. When I try to save this form error appear:
ou cannot add or change a record because a related record is required in table User (Error 3201).
Of course this record in this table doesn't exist. I need code how to save both User and UserDetails data together. Is that possible?
Thank you