Filling controls on two forms

[recon2011]

I have two forms that require a case number to be entered for new projects. One form is a time card form and the other is a project form. Right now when I open a new project I have both forms open one on top of the other. When I enter the case number on the time card form I need the case number to automatically fill in on the projects form. The forms have different tables but relationships have been established.

[rpeare]

If the field you're talking about is the same field you're using for the parent/child relationship is there a reason you're not using a form/subform. If you set it up this way you wouldn't have to 'copy' anything the child record would automatically inherit the field from the parent.

[recon2011]

The Projects form has a subform for time cards that shows limited data. But the TimeCard form itself needs to open from the Projects form in order for people to enter their daily activities. But when a new project is started, there is no link between the Projects form and the TimeCard form until the case number has been entered. (Both forms are linked through the casenumber field/control) After the project and time card are initially entered, the time card form can be activated through the project form and the casenumber field/control is automatically populated. It's only on the initial entry of a new record that I need addressed. Thanks for your help.

[rpeare]

Without an example database I don't really follow your data structure. However, the easiest thing to do would be to pass a variable from one form to the other when you open the secondary form. If you set an unbound field (set the visible property to false after you get it working) to the value of the previous form's parent unique key. Then whenever a new record is added to the secondary form you can have some code running that will force the foreign key to be equal to the unbound text box with something like:

me.fieldname = me.unboundfieldname