Putting values from 1 form into another

N

Nath

Hi.

I have one form (V_JObs) and another (V_Calendar) i wish
to put one button on the v_jobs form that opens
v_calendar. When the calendare is clicked i want one of
two controls (either start_date or end_date) which ever is
selected to take the value from the calendar.

Cany anyone help

TIA

Nath.
 
W

Wayne Morgan

As long as you ensure that the calendar will only be opened when one of the
two mentioned controls has the focus and that the focus won't change while
the calendar is open (i.e. open it with the acDialog window mode argument)
then you could refer to the control on the calling form by:

Forms!V_Jobs.ActiveControl = (the date from the calendar form)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the list form control: multi-selection possible? 3
How do I clear a form? 0
How to switch combo boxes? 1
Slideshow with black border around it 1
On Click, Open a form, choose a selection then have it populate fi 8
A couple questions BEFORE using Office 365 0
Why two rows in the form and only one in the recordset? 1
Data entry for a table from a form 1

Top