data entry

[tubar]

I have a form (form1) which gets its info from table 1. once I load this form and its data I want to use that data so when the user hits form 2 (which also gets its info from table1)(and which is strickly a data entry form) some of the information from form 1 is already inputed to form 2

Any ideas

 

[wazz]

if you close the first form first, the data will update and the second form will be up to date. or, use the same form and change the data entry mode. key is to save the data - force a save if necessary:

docmd.runcommand accmdsaverecord

 

[tubar]

ILL EXPLAIN IT DIFFERENT

I load a form that gives location specifications. It also has a subform that shows every light bulb that goes to that location. I want to a button that loads another form…and on this form the location specifications of the previous form are already loaded

 

[tubar]

Heres an example

 

[wazz]

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "Form2",,,"TheTableID = " & Me.IDControl

 

[tubar]

anyway you could update attachment