parameters for action query through form

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

parameters for action query through form

Author

Topic

kalsee
Starting Member

5 Posts

Posted - 2010-12-21 : 04:02:33

Hi guys, thanks for all the help!
Now I need to run an action query. How do I set it up so that data entered in a form will be the parameters for the query?

for example:
table2: id, name,address
action query - edit address in table2

the sql looks like this:

UPDATE Table2 SET Table2.[address ] = [enter address]
WHERE ((([enter id])=[Table2].[ID]));

so how can I take the info entered on the form to fill in these parameters of [enter id] and [enter address]?

thanks for your time!
kalsee

nheidorn
Starting Member

28 Posts

Posted - 2010-12-21 : 16:14:57

Microsoft has a help page with several options:

[url]http://office.microsoft.com/en-us/access-help/using-parameters-with-queries-and-reports-HA001117077.aspx[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources