If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tab controls not writing to table
Me again.
I am having a problem with my database, and just figured out what is happening. Next step...Why. I have several tables, whose fields are grouped together in a few queries, then one master query that contains fields from all of the queries. Finally, a form based off of the master query. On the form are a few tab controls. What I have noticed, is the controls on the form itself are working fine, but no information from the controls that have been placed on the tab pages are writing to the tables. Is there something simple that I am overlooking? You guys are batting 1000 today, hope you can keep the streak going. Thanks |
#2
|
|||
|
|||
Tab controls not writing to table
Jim,
Give us a couple of examples of the Control Sources of the text controls you have on the Tab page, and what table fields might be associated with them. I suspect you might have calculations in there, and that the controls are not "bound" to your table field/s. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Jim L." wrote in message ... Me again. I am having a problem with my database, and just figured out what is happening. Next step...Why. I have several tables, whose fields are grouped together in a few queries, then one master query that contains fields from all of the queries. Finally, a form based off of the master query. On the form are a few tab controls. What I have noticed, is the controls on the form itself are working fine, but no information from the controls that have been placed on the tab pages are writing to the tables. Is there something simple that I am overlooking? You guys are batting 1000 today, hope you can keep the streak going. Thanks |
#3
|
|||
|
|||
Tab controls not writing to table
Here's a quick breakdown...
I have an Investigation Table, with preliminary fields like "NInv" (Name of investigator), "NDate" (Date of accident), "NTime" (Time of accident). Another table is Conditions, with fields like "CWthr" (Weather conditions at time of accident), "CLit" (Lighting conditions), and "CRd" (Road conditions). The Invest query brings all fields of these tables together. A Veh query brings all fields from a Vehicles Table and Drivers Table together. Finally, the Investigation Query brings all fields from all queries together as the record source for the Input Form. The main part of the form has many controls (textbox and combobox) originally from the Investigation Table, and these are all writing to the table fine. All other controls (CWthr, CLit, VehA, Damage, {textboxes and comboboxes}) are on different tabs, and are originally from tables other than the Investigation Table. Although their control source is directly from the Investigation Query, they are not writing inputted information into their respective tables. I had planned to do different reports with the first step of queries, and that is why they are brought together the way they are, but now I am wondering if basing a query off of another query is what is causing this problem. All controls are showing the correct control source on the properties sheet, but are not writing to the field in the table. The recordset type is set to Dynaset (Inconsistent Updates). Isn't this correct for writing to multiple tables? Any ideas? "Al Campagna" wrote: Jim, Give us a couple of examples of the Control Sources of the text controls you have on the Tab page, and what table fields might be associated with them. I suspect you might have calculations in there, and that the controls are not "bound" to your table field/s. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Jim L." wrote in message ... Me again. I am having a problem with my database, and just figured out what is happening. Next step...Why. I have several tables, whose fields are grouped together in a few queries, then one master query that contains fields from all of the queries. Finally, a form based off of the master query. On the form are a few tab controls. What I have noticed, is the controls on the form itself are working fine, but no information from the controls that have been placed on the tab pages are writing to the tables. Is there something simple that I am overlooking? You guys are batting 1000 today, hope you can keep the streak going. Thanks |
Thread Tools | |
Display Modes | |
|
|