J
Joseph Rosing
Hi,
I have form which the user enters data into. Upon clicking a "Finish"
button, a query is run which takes the information from the form,
queries it against a linked table, and appends the results to an
internal table. The button also then takes the user to the next record
in the form. The macro steps are:
SetValue (sets a time stamp value on the form)
SetWarnings (No)
OpenQuery (runs the append query)
GoToRecord (New).
I have primary keys set up in the internal table which data is appended
to in order ensure only "new" data is appended.
The problem I'm having is that when the button is clicked, the form's
background table successfully logs the information from the form and
the form goes to the next record; however, the append query does not
run. If I then run the query from the database view, the query works
and appends the records to the internal table. Why does this work from
the database view and not from the macro?
The parameters of the OpenQuery macro are:
QueryName: SetupData
View: Datasheet
Data Mode: Edit
Thanks for your help.
Joe
I have form which the user enters data into. Upon clicking a "Finish"
button, a query is run which takes the information from the form,
queries it against a linked table, and appends the results to an
internal table. The button also then takes the user to the next record
in the form. The macro steps are:
SetValue (sets a time stamp value on the form)
SetWarnings (No)
OpenQuery (runs the append query)
GoToRecord (New).
I have primary keys set up in the internal table which data is appended
to in order ensure only "new" data is appended.
The problem I'm having is that when the button is clicked, the form's
background table successfully logs the information from the form and
the form goes to the next record; however, the append query does not
run. If I then run the query from the database view, the query works
and appends the records to the internal table. Why does this work from
the database view and not from the macro?
The parameters of the OpenQuery macro are:
QueryName: SetupData
View: Datasheet
Data Mode: Edit
Thanks for your help.
Joe