Form auto enter field on new record click

[Traceyann]

Hi


I have a form called "holiday homes" and on this form I have used a "button" to open another form called "maintenance records " linked by the pk fields "serial number". This works well, the data shows only the maintenance records for that holiday home which is correct but when I want to add a new maintenance record for a holiday home and click the arrow to add new record, the form doesnt automatically enter the serial number for that holiday home. Is there a way to do this?
Thanks
Tracey

[Missinglinq]

Are you talking about adding a new 'maintenance record' after you have the Maintenance Form already open? If so, you have to do this with a custom 'Add Record' hack.

If the Maintenance Form is a Single View or Continuous View Form, add a Command Button to the Form, name it 'AddMaintenanceRecord' and use this code, replacing [Serial Number] with the actual name of your Control that holds the serial number.

Private Sub AddMaintenanceRecord_Click()

 'Copy serial number field to variable

 SN_Variable = Me.[Serial Number] 

 'Go to a new record

 DoCmd.GoToRecord , , acNewRec

 'Reverse the process and plug old serial number value into new record

 Me.[Serial Number] = SN_Variable 

End Sub

If the Maintenance Form is a Datasheet View Form, that doesn't allow for Command Buttons, you'd have to use the same code in the Double-Click event of a Textbox.

Linq ;0)>

[Traceyann]

Thank you that sounds like the solution that I'm looking for.

[Missinglinq]

Glad we could help!

Linq ;0)>