Major Advise Needed "dan.cawthorne[ at ]gmail.com" <dan.cawthorne[ at ]gmail.com> 12/22/2008 3:19:42 PM Hi All, Need some help, cant seem to get what i want to work? So I have a fully working Database that is populated with Enquirys? and one of the fields i have added is a "Exporttocontracts" Ive then created a separate table in a contacts back end, and the theory behind what i want to do is all the projects that have a tick in the field "Exporttocontracts" when i run an append query the records are added to the contracts table. which i used a view query using criteria's to only shows the required records. with a field called Exported Date. Which ive managed to accomplish. what i cant is achieving the selection process via a form, What i would like is a user to open a form, Select the project,Via Drop down list then tick the "Exporttocontracts for that selected project, then click finish and then that button runs the append Query and Update Query, which puts todays date in the Exported Date field which stops that record from showing Does this startup form need to be unbound?

Re: Major Advise Needed "Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 12/25/2008 4:07:25 AM <dan.cawthorne[ at ]gmail.com> wrote in message news:032b8475-6083-47ac-9fc2-0d9347617131[ at ]d36g2000prf.googlegroups.com... [Quoted Text] > What i would like is a user to open a form, Select the project,Via > Drop down list then tick the "Exporttocontracts for that selected > project, then click finish and then that button runs the append Query > and Update Query, which puts todays date in the Exported Date field > which stops that record from showing > > Does this startup form need to be unbound? No, it doesn't need to be unbound, but you should do the following in your button code: 1. Save the record 2. Run the Append Query 3. Run the Update Query 4. Requery the form so that the results of both queries are propagated to the form. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com