Issues with Subform data

M

MEAD5432

I have a form with a subform that allows the user to update information about
a customer.

The first record of my data shows up every time regardless of the selection
I make on the form. It also changes the customer information for this first
record and changes the information according to the criteria on the form.

The form and subform work correctly otherwise.

How do I make it stop?
 
M

Miranda

It sounds like you are just editing your record. Are you using the form to
choose which employee and the subform to make the changes? If so, maybe you
should use a query to pull the correct employee and open the form/subform to
edit.
 
J

John W. Vinson

I have a form with a subform that allows the user to update information about
a customer.

The first record of my data shows up every time regardless of the selection
I make on the form. It also changes the customer information for this first
record and changes the information according to the criteria on the form.

The form and subform work correctly otherwise.

How do I make it stop?
Click to expand...

How are you finding the record? with a Combo Box to select a customerID? If
so, the combo box should be UNBOUND, otherwise it will overwrite the ID in the
first record of the table!

What is the Recordsource of the mainform? of the subform? What are the
subform's Master/Child Link Field properties?

John W. Vinson [MVP]
 
M

MEAD5432

I have a text box that opens the records in the subform according to
"Officer".

I only have one table that both the form and subform are linked to. The
master/child link is "Officer" on the table.

Let me know if you have other questions.
 
J

John W. Vinson

I have a text box that opens the records in the subform according to
"Officer".

I only have one table that both the form and subform are linked to. The
master/child link is "Officer" on the table.

Let me know if you have other questions.
Click to expand...

Why would you have the SAME record open on both the main form and the
subform??? At best this will give you errors like "the record could not be
edited because it is opened by another user" - if the same record is opened on
both the form and the subform, one won't be able to edit.

What is the Primary Key of this table? What is the meaning of the Officer
field?

John W. Vinson [MVP]
 
Top