Update field on one form from nother

  • Thread starter Andrew @ CrazyCritters
  • Start date
A

Andrew @ CrazyCritters

Hi,

I have a form 'Frm_New_Booking'. On it I have a button to open another form
with a calendar on it so the user can select a date. The result ends up in a
variable 'The_Date'. There is a button on the form to close the form. I
want the value of the variable 'The_Date' to be placed in field 'DOB" On
'Frm_New_Booking'.

Please advise.

Andrew
240508
 
W

Wayne-I-M

Hi

There are other ways to do but I would just add a line of code to close
button on your calender form t set the alue of The_Date on the new booking
form (This only works if both forms are open). If you have closed New
Booking form, post back for a slightly different code


Private Sub ButtonName_Click()
Forms!Frm_New_Booking!DOB = Me.The_Date
DoCmd.Close
End Sub
 

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

How to tell if a field on a form has changed? A control? 2
Need combo box to refresh when moving to new record 2017 1
Update Form Field from another Form 6
Access Sub form opens before the main form in MS Access 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
On Click = now 6
How do I obtain a value from an external form? 3
Open form to specific record from button on continuous form 4

Top