Updating table with information from Form input.

[Guest]

I have a table (Dispatches) with 16 fields. Have developed a Form used to
input data for the table. The form is based on a Select query. All data is
save properly with the exception of 3 pieces (driver ID number, company
driver number and telephone number) The information is shown in the form but
doesn't get stored in the table.

 

[Jeff Boyce]

Dave

If a form has a control, but that control's value doesn't get stored in the
table on which the form is based, usually you'll find that the control is
not bound to the field into which the data should go.

Open your form in design view. Click on one of the controls that isn't
"saving". Open the properties. Is there a value in the Control Source
property?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I checked and all three controls are set. However, they are bound to the
Employees table instead of the Dispatches table. I tried to change control
to Dispatches table, but that didn't work.

 

[Jeff Boyce]

Dave

We're not there. We can't see your application.

More specific description may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I can supply detailed information. Whatever you need. I can also upload a
copy of the program with only 3 tables, one query and one form. It is about
600 KB. Let me know.

 

[Jeff Boyce]

Dave

Posting and responding stays here in the group. That way, many folks can
find the Q & A and benefit.

Nearly all the folks who respond here are volunteering their time. Try
posting more specific information about your table structure and
relationships.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I have 3 tables: Customers, CompanyID primary key, 17 fields, no lookups,
Employees, EmpID primary key, auto number, 20 fields, no lookups, Dispatches,
DispatchID primary key, auot number, 21 fields.
Have 1 query: Table- Dispatches, Dispatches*, EmpName No show, Date, no show
[Enter Dispatch Date]
1 form: 2 combo boxes: CompanyID 1 field bound 1. EmpName, 4 fields, EmpID,
EmpName, SMT Number, TelNo Bound to EmpName
Relationships: Customer - Dispatches (CompanyID) Employees - Dispatches
(EmpName)
Hope this helps.

 

[Jeff Boyce]

Dave

Open the Select query (you use to feed the form) in design view. Change the
view to the SQL view. Copy the SQL statement.

Paste the SQL statement into your return email. I wasn't able to tell from
your description how your SQL/query is returning data, nor from what
table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Here is SQL:
SELECT Dispatches*
FROM Dispatches
WHERE (((Dispatches.Date)=[Enter Dispatch Date]))
ORDER BY Dispatches.EmpName

--
Dave Barnes

Dave

Open the Select query (you use to feed the form) in design view. Change the
view to the SQL view. Copy the SQL statement.

Paste the SQL statement into your return email. I wasn't able to tell from
your description how your SQL/query is returning data, nor from what
table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have 3 tables: Customers, CompanyID primary key, 17 fields, no lookups,
Employees, EmpID primary key, auto number, 20 fields, no lookups,
Dispatches,
DispatchID primary key, auot number, 21 fields.
Have 1 query: Table- Dispatches, Dispatches*, EmpName No show, Date, no
show
[Enter Dispatch Date]
1 form: 2 combo boxes: CompanyID 1 field bound 1. EmpName, 4 fields,
EmpID,
EmpName, SMT Number, TelNo Bound to EmpName
Relationships: Customer - Dispatches (CompanyID) Employees - Dispatches
(EmpName)
Hope this helps.

 

[Jeff Boyce]

Dave

You have a form based on the query below. But three of the controls on the
form are bound to some other table's data fields.

I don't understand how they are bound to the other table's fields. How do
you know that they are?

Have you selected one of those fields, clicked on Properties, and used the
drop-down arrow next to the Control Source to set the source for the field
to one of the fields in the [Dispatches] table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Here is SQL:
SELECT Dispatches*
FROM Dispatches
WHERE (((Dispatches.Date)=[Enter Dispatch Date]))
ORDER BY Dispatches.EmpName

--
Dave Barnes

Dave

Open the Select query (you use to feed the form) in design view. Change
the
view to the SQL view. Copy the SQL statement.

Paste the SQL statement into your return email. I wasn't able to tell
from
your description how your SQL/query is returning data, nor from what
table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have 3 tables: Customers, CompanyID primary key, 17 fields, no
lookups,
Employees, EmpID primary key, auto number, 20 fields, no lookups,
Dispatches,
DispatchID primary key, auot number, 21 fields.
Have 1 query: Table- Dispatches, Dispatches*, EmpName No show, Date, no
show
[Enter Dispatch Date]
1 form: 2 combo boxes: CompanyID 1 field bound 1. EmpName, 4 fields,
EmpID,
EmpName, SMT Number, TelNo Bound to EmpName
Relationships: Customer - Dispatches (CompanyID) Employees - Dispatches
(EmpName)
Hope this helps.