Appending Combo Box selection to another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a form that will allow the user to select a date from a combo
box to base the rest of the criteria on (using month end dates) and can not
get the selection to append to another table that will run the rest of the
queries. Can you help or suggest another way?

I have used this in other forms in the past but it has been so long since I
completed it that I have forgotten how.

Thanks
 
Hi Geoff,

You could either have your queries pick the date up directly from the combo
box, eg: select * from TABLENAME where DATEFIELD <= forms!FORMNAME.DATECOMBO

Or if you specifically want to insert the date into another table (for some
reason), have an after update event on your combo box similar to this:

docmd.runsql "insert into TABLENAME (DATEFIELD) values (#" &
format(me.DATECOMBO, "yyyy/mm/dd") & "#)"

Hope this helps.

Damian.
 
Back
Top