Remember from previous Form

[UTK]

Hi,
I am working on a database that stores maintenance records. I have created several forms and tables. One form, ServiceInfo, holds the basic information for each work order. And another form, ServiceDetails, holds the specifics. I have a command button on ServiceInfo that opens a new ServiceDetails form. I am trying to get Access to copy and paste the work order# from a text box in the first form to the work order# box in the second form. The WO# is how the two forms are related, and this would allow the database to update both talbes. How can i do this? Or is there a simpler way to do so?

 

[WayneRyan]

UTK,

Set the DefaultValue for the [WO#] field to:

=Forms![YourMainForm]![WO#]

hth,
Wayne

 

[UTK]

Sweet! It worked. I appreciate it.