Updating a table through a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to update a table with values that I have on a form. I've written an Update Query that has its Criteria (or source) as a Textbox on the form. I've also tried ListBoxes as the 'source'. The query is launched from a Command Button on the same form. Whenever I run the query, it always says that "0 rows will be updated". The table fields are text, so I don't see a problem with type compatability. I've run out of ideas to try, so any ideas/suggestions would be great
Thanks.
 
Start over! Use the form wizard to build your form basing the form on the table
you want to update. Once you have the form, anything you enter in the form will
automatically be recorded in the table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


MuddyJoe said:
I'm trying to update a table with values that I have on a form. I've written
Click to expand...
an Update Query that has its Criteria (or source) as a Textbox on the form.
I've also tried ListBoxes as the 'source'. The query is launched from a Command
Button on the same form. Whenever I run the query, it always says that "0 rows
will be updated". The table fields are text, so I don't see a problem with type
compatability. I've run out of ideas to try, so any ideas/suggestions would be
great!
 
The table fields are text, so I don't see a problem with type
compatability
Hmm, the problem you outlined mostlikely points to a datatype error ...

Repost the commandbuttons click event.
show the SQL code of the update query as well

Krgrds,
Perry

MuddyJoe said:
I'm trying to update a table with values that I have on a form. I've
Click to expand...
written an Update Query that has its Criteria (or source) as a Textbox on
the form. I've also tried ListBoxes as the 'source'. The query is launched
from a Command Button on the same form. Whenever I run the query, it always
says that "0 rows will be updated". The table fields are text, so I don't
see a problem with type compatability. I've run out of ideas to try, so any
ideas/suggestions would be great!
 
Back
Top