Opening a form for a new record and using a value in a combo box 1

[oneeyedwilly]

Hi,

I would like to open a form to enter a new record and use information from the original form to populate a field on the second form.

combo box on form 1 = field on form 2(new record)

 

[PhilWB]

Perhaps DLookup can help you.
Take care, Phil

 

[TheAceMan1]

How are ya oneeyedwilly . . . . .

Try this ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   DoCmd.OpenForm "[purple][b]OpenedFormName[/b][/purple]", , , , acFormAdd [green]'Data Entry Mode[/green]
   Forms![[purple][b]OpenedFormName[/b][/purple]]![[purple][b]TextboxName[/b][/purple]] = Me!ComboboxName.Column(1)[/blue]

You may have to play with the column number to get it right.

See Ya! . . . . . .