Pass text - Old Access renegade (1 Viewer)

[TurboDieselOne]

Right old user been away from access for ages and into Excel but new company new toys. Well old toy really new version.

Form 1 opens and I have first Name, Last Name, Company now next to Company is button that opens a popup form that has a combo which uses a query to list the only the companies and from my list of tables as some names are just well not attached to Companies.

Right Step 2
one selects the COmpany from the list presses the oK button on this popup form and then the text is passed from the pop up form to the Company field Form1

Years ago i could do this but forgot so much in the last 5 years from not using Access.


Thanks in advance

 

[boblarson]

You could use (in either the click event of the ok button or the close event of the form):

Forms!TheFormToUpdateNameHere.ControlToUpdateNameHere = Me.ControlIJustSelectedFromNameHere

That is generic - change the names to your own.

 

[TurboDieselOne]

Great Thanks for quick reply. I'm sure all these things will creap back into memory once I start using Access again.