Complicated append query

[Guest]

Hi all ,

I have a form that has two things:
an inbound txtbox (updatingdate) and a button "Update" I want to do the
following :
Click on the button "update" and run an append query to append "agents
information" table to "swap form" table ..
Knowing that each time i append this table i'll insert 35 rows to the
table "swap form" ,same time i want to append a date, which is indicated on
the txtbox "updating date"on the form, infront of the 35 rows..? so each
agent will have a date infront of his name ? How can i do this ?

 

[Arvin Meyer [MVP]]

Add a column to your update query:

UpdateDate: Forms!YourFormName!YourFieldName

and set the append field value to the field you want updated. A simple
example would look like:

INSERT INTO MyTable ( ID, UpdateDate )
SELECT ID, [Forms]![YourFormName]![txtDate] AS UpdatedDate
FROM SomeOtherTable;

 

[jrjrfurg]

hy