I have a form that was created for data entry. For the majority of the information it automatically shows up in the table as it should. However, I have several fields that do not show up in the table. A couple of them are calculations and others are simple entry fields.
I have made sure that the fields are coordinated in both the table and the form, i.e. if currency, etc.
The information does show in the database view of the form.
I believe the problem goes back to the importing of information from a previous database -- because everything works on the data from the old database, the problem only shows up after the new records have been input.
I am totally at a loss on how to coordinate the two.
Thanks in advance
I believe we will need additional information before we can take a reasonable guess as to the problem. You should be aware that as a general rule, calculations do not belong in fields; just recalculate them when you need the data. Are the controls that do save data bound to fields in the underlying table? In other words, do these controls have a ControlSource?
form fields to table fields
Yes, the control source comes from another field in the same table (form). That does work in other parts of the form however, so it has to be something more than that. And, unfortunately, I don't have enough depth of knowledge to work my way through.
I've tried to attach a zip file of the db but it is too large. Not sure how to attach just the forms and tables.
The two issues I am having - that have the same problem.
1. frmFinancialFirstMeeting (the last 15 fields on the form) - some carry over and some don't
2. tblFinancialfirstmeeting (those fields on the last 8-9 entries only)
The second case:
1. frmRegistration, sbfMemberInfo - here the information for "counties" carries over to tblMemberinfo for the first 325 as names of counties and for the last 20 or so as the auto number from the look up table.
Thanks so much. The more I learn, the more I want to learn, but when I get a big road block I can't wrap around it gets very frustrating.
Make sure that BEFORE you try zipping the file that you use:
Tools > Database Tools > Compact and Repair
zipped dbase
learn something new every day - and that is good.
Just for the record: forms have controls and tables/queries have fields. Any control that has a calculation as its ControlSource is not bound to a field and so the results of the calculation will not be stored in a table. Here's some links with which you should probably become familiar:
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases
Provide the names of the controls that are not working as you would wish. Each control on your form has a unique name.
Controls not doing what they are supposed to do on two different forms:
1. CurrentPremOpportunity Control Source: =[AveCwtMilkShipped]*[PotentialDifference] Tab 18
2. Milkprice/lb Control Source: =[MilkPrice] Tab 22 (price comes from earlier in form)
3. AveCostDiscardedMilk Control Source: =[# days]*[lbs/milk/day]*[MilkPrice] Tab 23
4. LostFromClinicalMastitis Control Source: =[TotalCostPerCase]*[NumberClinicalCasesLstMo]
The stymie to me is why calculations work and show in the earlier part of the form and not in the later part of the form.
1. Combo Box: County Control Source: County Row Source Type: Table/Query Row Source: SELECT tblzCounty.County_ID, tblzCounty.County FROM tblzCounty ORDER BY [County];
In this control the information provided to the earliest part of the table is in name form. In information provided to the table after the db switch is in number form.
I understand about calculations not needing to take place until you run a report. However, in this instance we have field reps who pull up the tables in read only form to compare data between different farms. I wrote a query that basically pulls up the table - perhaps there is a better way to go in that. . but that is as far as I have gotten to give them what they want.