Automatic Subform Entry

[Neilw]

What i want is that when a particular field on a form is exited (i.e. you tab out or select another field with the mouse), then the first record is entered automatically into the subform. This automatic record will be the same value every time. Is this possible?

 

[Fizzio]

What exactly do you mean by 'the first record is entered automatically into the subform' Do you mean carry the details over from a main form into a subform, show the first record in that forms recordset or create a new record?

 

[Neilw]

Sorry, i meant create a new record in the subform but with specific data. This specific data is not stored anywhere else in the database, it would have to be specified in the expression/code.

 

[Fizzio]

Do you want to have the same default value all of the time or dependant on the record in the main form? If it is the same value all of the time, in the default value property of the field control you want just enter =Whatever you want use "whatever" if it is text.
HTH

 

[Rich]

What would be the objective of storing the same data multiple times?

 

[Fizzio]

Rich, could be a default date? or link to an employee ID

 

[Rich]

Not according to this
This specific data is not stored anywhere else in the database, it would have to be specified in the expression/code.

 

[Fizzio]

If 'This specific data is not stored anywhere else in the database, it would have to be specified in the expression/code' then he would not be duplicating it (Well not on the first time he entered it anyway

) I know where you are coming from but I gave him the benefit of the doubt!