Updating ms access table from form

You should note the difference between updating form controls, and updating the underlying database field values. Requery method if you update database field values, so as to update the display with the new values you've put into the fields using VBA code.Can you describe your issues and designs in any more detail?Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.

updating ms access table from form-90

However, this should not prevent us from discussing a few techniques that will help you.

I presume you've already got some VBA code set up, since you mentioned that you've already "connected" some of these controls (though you haven't explained how).

Generally speaking, instead of using the Form "Filter" features built in to Access, I modify the form recordsource property using code like this: You can create the WHERE clause using VBA code (take precautions to wrap your fields in delimiters, and to escape any delimiters that might be embedded within the data supplied by your users - it can lead to "SQL injection" vulnerabilities if you don't do this.) Your WHERE clause could include conditions (for example) on employee_id.

Run SQL "UPDATE tbl Catalog" & _ " SET tbl Catalog.

Close Exit_Choose_Synonym_Click: Exit Sub Err_Choose_Synonym_Click: Msg Box Err.

PKey] as a bound textbox in the pop-up form and it works. If the PKeys are integers try: str SQL = "UPDATE tbl Catalog" & _ " SET tbl Catalog. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. I am trying to update a table from form values in Access 2k. Description Resume Exit_Choose_Synonym_Click End Sub I get a "datatype mismatch on criteria expression" and can't figure out why (everything is Long Integer). This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. In the following code "tbl Catalog" is the table to be updated. "Me." is a form opened from frm Entry Form as a pop-up to choose the parent record. Private Sub Choose_Synonym_Click() On Error Go To Err_Choose_Synonym_Click Do Cmd.