Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Parameter

Status
Not open for further replies.
JWS6

JWS6

IS-IT--Management
Aug 22, 2001
2
ZA
When I use the following SQL to delete a record I get an Enter Parameter Value Box wanting the value for AC. The box also dispays the correct value for AC above the open field. It will only run the SQL if I manually copy the displayed AC value into the blank field. This SQL works great in other modules.

DoCmd.RunSQL ("Delete * from Clients where [AC]=" & [Forms]![RemAC]![AC] & ";")

Any ideas?
 
Sort by date Sort by votes
The form is open. Me.Visible=False. Problem occurs if Me.Visible=True as well.
Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
620
Swi
Swi
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
275
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
311
dhookom
dhookom
teamssc
  • Locked
  • Question
Trouble with Parameter Query 1
Replies
4
Views
251
Andrzejek
Andrzejek
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
267
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top