Major Advise Needed

[dan.cawthorne]

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?

 

[Arvin Meyer [MVP]]

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.