All you have to do is make sure the field that connects the two forms is filled in (the primary key and the foreign key). Then refresh the form you could attach the refresh event to the code for the button that opens the new form.
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dimitris Sent: Monday, June 25, 2007 3:27 AM To: [email protected] Subject: [ms_access] form fields filled in automatically acording to another form (or something :^) Hi all, i have a form A connected to a table A and I have placed a button there that will open a form B that connects to a table B. A couple of fields r common in these two forms/tables. How can I make it that when form B opens these common fields get their value automaticaly filled in according to the corresponding fields of form A? Visual Basic I suppose, but how? Thanks in advance. I love you :) Dimitris No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM [Non-text portions of this message have been removed]
