473,320 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Refreshing form data when table contents change in access 2010

Hello,

I have a comboBox field named "FullName" that pulls data from a table then populates other fields. When I edit the records on that table, the changes are not reflected on the form.

I have tried the me.Refresh and the me.Requery approach and it does nothing.

What would be the best way to handle this so that changes made are reflected on the form without having to re-select data from the comboBox?

I have several fields in the same situation.

Greatly appreciate it,

Alex
Mar 19 '15 #1
5 1365
Seth Schrock
2,965 Expert 2GB
Is the information that is changing on the form or in the combo box? Something else to look at is to make sure that the changes have been saved when you perform the requery.
Mar 19 '15 #2
@Seth Schrock
The information that is changing is on another table that the combobox looks up. For example, I enter info on the form, data on the FullName field looks up data on a table and populates other fields based on the choice made on the combobox. Data is saved on the form. Then at some point the table that the combobox got its info from, is updated. When you load the form again, naturally, the items that were changed on the other table are not reflected on the form, thus you have to click the combobox and re-choose from the list so that the changes are populated on the respective fields...
Mar 19 '15 #3
Seth Schrock
2,965 Expert 2GB
This sounds like you are copying the data from the one table to the other when you make your selection in the combo box. Is this correct?
Mar 19 '15 #4
Maybe..., this is the way I'm doing it. The table, actually using a query, "qryEmployees" (linked to "tblEmployees"), is the rowsource used by the "FullName" combo to populate the list. The query contains about 30 columns, I use the Column Widths property to just display the employee full name. The, on the On Change event of the combo I have something like this:

Expand|Select|Wrap|Line Numbers
  1. Me.PositionTitle = Me.FullName.Column(1)
  2. Me.PositionType = Me.FullName.Column(2)
  3. Me.Grade = Me.FullName.Column(3)
Etc... When you choose a name, it populates the respective fields. On the form say the title is Manager, I save record, close form, edit the "tblEmployees" and change the title of that person to Supervisor. When I re-open the form, the title still says Manager, in order to change it, I have to go to the combo and re-select that employee from the list, then the record gets the new info...

Thanks...
Mar 19 '15 #5
Seth Schrock
2,965 Expert 2GB
So yes, you are copying the information from tblEmployees (via qryEmployees) to the table that your form is bound to. This problem that you are having is the reason that you don't copy the data over. Instead, if you just use the combo box to create the tie between the two tables, you can use a query to get the data across. You should look at Database Normalization and Table Structures.
Mar 19 '15 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Marco Alting | last post by:
Hi, I have an HTML form which enters data in an Access database using ASP. But now my client asked me if it is possible to alert users, when they click a link other then submit on the page, that...
1
by: nic | last post by:
Hi I have two forms form1 and form2. I am trying to get all the data entered in form1 to be updated to the table on an event. ie. when I click the button to load form2, I need the data from...
1
by: Spyderman | last post by:
I am fairly new to access but I have found a problem I don't have an answer for. I have a form based on a table. If I change the properties of a field in the table, I was hoping the changes would...
5
by: antonyliu2002 | last post by:
I have 4 forms each on a separate page respectively form1.aspx, form2.aspx, form3.aspx, form4.aspx. On top of each of the four pages there are 4 links which link to the aforementioned 4 pages...
4
by: Stan | last post by:
I am working with MS Office Access 2003 11.5614 on a computer running XP. If I change a property such as the input mask in a table, to have the change reflected in an existing form I have to go...
1
by: burtell | last post by:
Previously, I wrote: I have designed an HTML form. The name of each element corresponds to a heading in an Access database on my computer. Is there a way for me to program the HTML form to send the...
4
beacon
by: beacon | last post by:
Hi everybody, My title may not exactly describe my issue, so please forgive my lack of creativity today. I've got a database that was created in Access 2003 that I've opened in Access 2010. I...
11
by: Redbeard | last post by:
I have just upgraded to Access 2010 (64 bit) from Access 2007. There were a few minor issues in the database which I have resolved but this one piece of code just won’t work. I do not write VBA but...
1
topher23
by: topher23 | last post by:
A layout provides a grouping method for controls on a form or report. The two default layout types are Tabular (labels in form header, controls in detail), and Stacked (labels to the left, controls...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.