I am currently using a form on my database that shows customer data, e.g. Unique i.d. code, Name, Number. On that form itself, there is a button that i have created that will open a secondary form related to that specific customer. That form also has the unique i.d code, name and number fields, i want them to be filled in automatically, based on the previous form. I have been informed that the best way to it is to write code in the "before insert" properties source. I am a little stuck, if anyone out there understands the problem, please could you provide some help.
Thank you for your post. Both the forms are bound. Both of the forms use a primary key, but i do not understand what you asked me about "a foreign key relationship between the two datasets"? In the mean time i will try the code.
Hi, i have just tried the code and it doesn't seem to work with what im trying to, have you got any further idea's?
Both forms were made using the wizard which has a table affiliated to it in order to hold the data. I simply need the data in 5 of the fields in form 1 to automatically appear in the second form when it is opened. I think i have to generate some code in the "before insert" properties box in the second form...but im not sure how to do this. If anyone can help, that would be really good.