Tab controls not writing to table

J

Jim L.

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
 
A

Al Campagna

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."
 
J

Jim L.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top