Populate date for an append query from an unbound control on a form

[chrisargo]

I would like to have the user enter a date in an unbound text box on a form. Then I want to use an append query to automatically generate several assignments for three different time periods using that specific date as the date of the assignment. The way I envision setting this up is by executing three separate append queries via command buttons on the form where the date was entered.


I can successfully do this without the use of a form by prompting for the date in each query as follows: Assignment Date: [Enter Assignment Date].




However, I would like to make it so the user only has to enter the date one time and then they can generate the necessary assignments for that date by clicking the individual command buttons since not every time period or group of assignments is used each day.


Any thoughts or maybe an alternative way to accomplish this goal?

[June7]

Maybe:

Assignment Date: Forms!formname!textboxname

[chrisargo]

My apologies. I should have included this with the original post. I tried that within the query by using the builder as well as by typing directly into the query. The query returns the assignments I am looking for but does not populate the date. Any other thoughts?

[June7]

Post full SQL statement of the INSERT query.