Small problem with my update query...

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

OK, here's the deal: I have a database with 5 tables, and
I need to copy data from one field in Table A to the
corresponding fields in Tables B, C, D, and E (all have
primary keys that are autonumbers, and all these are
joined in the query). So I have an update query to do
just that. At the moment, it seems to work, except for
one little "glitch" - when I go to the Queries tab and run
the query, it asks me for the parameter for the field-to-
be-copied in Table A. Now, I'm new to Access, and maybe
it's supposed to or has to do that, but the thing is I
don't want the user to have to type in the parameter
because the user probably won't know what that means/what
to do. Essentially, I'd like the database to just copy
the appropriate field after the user runs the query, no
questions asked. For example: the user enters in an 8
digit number into the field OrderNum in Table A, when the
primary key value is 1. I want OrderNum to be copied to
the other Tables when their primary key value is 1. The
same goes for each subsequent entry (when the primary key
values are 2, 3, 4, etc.), but without having to worry
about the parameter. I know this example is a bit fuzzy,
so I hope I got across what I'm trying to do. Any help
would be appreciated. Thanks.
 
Thanks for the advice, but I'm still having problems. I
tried putting [TableA].[OrderNum] in "update to," but
still was asked for parameters. I also tried [Tables].
[TableA].[OrderNum] in "update to," but also got the same
result. Am I doing this incorrectly, or is there a
problem with my syntax?
 
Back
Top