Populate a field (1 Viewer)

[TVReplay99]

Is ther a way to polulate a field on a form from date from a previous form. I want to transfer what is selected in a combo box to the new form for date entry.

Brian

 

[ghudson]

Set the Control Source of the text field to the combo box from the other form...

[Forms]![OtherFormName]![ComboBoxName]

That "other" form must be open.

HTH

 

[TVReplay99]

How do I do that with a bound field? The control source is from the query the form is based on.

Brian

 

[ghudson]

Assign the code to an event [command button] to set the value of that field to [Forms]![OtherFormName]![ComboBoxName]

 

[TVReplay99]

How would I do that/ I tried using Form events like On Load and Before Insert. Those didn't work for me.

I am wondering if it has anything to do with Data Entry set to Yes.

Any thoughts.

Brian

 

[Rich]

DoCmd.OpenForm etc
Forms!SomeNewlyOpenedForm!YourField=Me.YourControl


on the same button