Data not being saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Form is based on a combobox that pulls 1000s of records. The combobox record
source is a query that is based on customer numbers. The form does not
consistently save changes to records. However, if the same form is modified
to pull only a single record (i.e., not based on a combobox of 1000s) then
changes are saved.
 
How are you making "changes to records" ... i.e., to more than one record at
a time? Usually, a form displays a single record, and Access saves the
changes when instructed, or when another record is called up.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Form is based on a combobox that pulls 1000s of records. The combobox record
source is a query that is based on customer numbers. The form does not
consistently save changes to records. However, if the same form is modified
to pull only a single record (i.e., not based on a combobox of 1000s) then
changes are saved.
Click to expand...

A form cannot be "based on a combo box".

A combo box is a *tool* which displays data from a table; a Form is a
different kind of tool which displays and allows you to edit data in a Table.

What is the Control Source of the combo box?
What is its Row Source? (a combo does not HAVE a record source).
What is the Recordsource of the form?
What are you actually doing with the combo?

John W. Vinson [MVP]
 
Thanks for replying.
What is the Control Source of the combo box?
Click to expand...
The combo box box does not have a Control Source
What is its Row Source? (a combo does not HAVE a record source).
Click to expand...
Row Source: Order Inquiry_by Cust_Number rowSource_for ComboBox
What is the Recordsource of the form?
Click to expand...
Record Source of the form is a query: Order Inquiry & Cancellations
What are you actually doing with the combo?
Click to expand...
The intent of the form (with a combobox) is for the users to be able to use
the "type ahead" feature to find particular records. If a user wants to pull
Cust_Number 4589, they could either type 4589 and the record will show, or
when they type 4 (and pause), customer numbers beginning with 4 would appear
(set to show 10 customer numbers at a time). When they type 45 and pause,
records with Cust_Number beginning with 45 would appear. And so on. This
feature has been working fine when users only want to query info. But, if
they want to change a particular field, it does not work.

I have a save button that user’s use to save the record, before moving on to
a different Cust_Number.

Thanks
 
Back
Top