Updating arecord in access form teenage stress factors dating

27-Mar-2020 23:37

If the main form displayed the sales rep and the sub displayed all the accounts he/she had, what kind of changes on the sub should be affecting the one side of this relationship? As mentioned in my last post, I don't have the benefit of seeing your code, so I think there's nothing else I can offer. What is the best way to display the new info in the parent form while staying on the same record? Slush As far as I can recall, doing a refresh instead should do what you want. I am trying to do this using the after update event on the sub form.I presume only one person at a time could be adding records to the underlying data, so there would be no need to reload the form, which deletes any bookmarks and moves to the start of the recordset. Is there another way to get refresh to work or any other suggestions? Run SQL str SQL Cheers Ray quote: Originally posted by Ray Pinnegar If the PKeys are integers try: str SQL = "UPDATE tbl Catalog" & _ " SET tbl Catalog. I have a sub form where users can edit/change values displayed in the parent form. 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).

Once you've created such an empty database, you could work your way through all of the tables to fill them with information. It's hard to follow relationships between data in tables while you're trying to enter in data. You can design input forms so you can enter data in a logical format The benefit of using your new Access Input Form is that you don't have to find individual fields in the table to enter the data.To initiate the Find and Replace dialog box, first click in the field you want to search through, then click Edit – Find using the menus at the top of the Access window.