Macro Errors

  • Thread starter Thread starter J
  • Start date Start date
J

J

When I click a button on a form I get an error saying that a field
can't be defined more than once. It then goes to give infomation on 2
macros that I have (name, action, arguements). If anyone could tell me
how I could fix this problem it would be greatly appreciated.
 
J,

Can you please give full details of the macros, actions and relevant
arguments, and also the exact wording of the error message? Thanks.
 
The error message says "Cannot define field more than once" The 1st
macro is a create table macro, condition True, Action Name "Open
Query", Arguements "Status, Datasheet, Edit"

The 2nd Macro is named "Macro 4", condition True, Action Name
"RunMacro", Arguements "CreateTable, ,"

The CreateTable Macro sets the warnings off, opens up 3 different
queries and then turns warnings back on again.

Macro 4 Turns warnings off, opens 2 different queries, runs the
CreateTable macro, sets warnings back on, displays an "Update
Complete!" message and changes a text box to display the current date.

I hope this is all the information you were looking for.
 
Back
Top