Bill -
Using a form to capture This Year and Next Year is probably the best approach:
Insert Into MyTable (Year, OtherStuff)
Select Forms!MyForm!NextYear, OtherStuff
From MyTable
Where Year = Forms!MyForm!ThisYear
Where NextYear And ThisYear are the combo boxes on MyForm.
- - The bound column of each combo box is the year
- - Query will need to do a type conversion if MyTable.Year is numeric
- - For example: CLng(Forms!MyForm!NextYear)
Haven't checked this for syntax but you get the idea.
- Brian
On 30 Jul 2004 02:05:19 GMT, Bill Hesson <wh*****@cox.net> wrote:
Thanks for the response!! the database is set up the way you suggested.
what I am trying to do is provide a way for the users to enter the
course information by having the courses automatically entered from last
year and then just edit them from there. so I am thinking of using an
append query to select the dasired year to copy the course info from and
what year to copy it to. my problem with that is that I want to use a
combo box to fill the year to copy from and the year to copy to. what
do you think. I haven't been able to figure out how to use combo boxes
in a query unless I possibly use a form to fill the query fields.
thanks again!!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!