Form Freeze! (New to Access)

[parttime_guy]

Hi Guz,

I am new to MS Access 2007 – have a small problem.

My data consist of about 10 colums, I have a created a form for the same. Within the form I have a combo box which list all details from column C.

When I use the Next Record button all the details including the Combo box change/reflect the right information as shown in the Data.

Problem: When I choose the Combo box – the selected information shows on the screen – but all the other information freezes – and another scary thing :bug: is that the freezed information gets saved to the information selected in the Combo box.

Any ideas.

Plz help

Thx-n-BR

[OBP]

What is the Control Source of your Combo?

[parttime_guy]

Dear OBP,

As requested below (I hope this is what u need)


Control Source: Acc_Name
Row Source: SELECT from table
Row Source Type: Table/Query
Bound Column: 1
Limit to List: Yes
Allow Value List Edits: No
List Items Edit Form: FormTracker
Inherit Value List: Yes
Show Only Row Source Value: No
Input Mask: Blank
Default Value: Blank
Validation Rule: Blank
Validation Text: Blank
Enabled: Yes
Locked: No
Auto Expand: Yes
Smart Tags: Blank

Iam really lost - Kindly help

Thx-n-BR

[OBP]

That looks OK.
What is the Record Source for the form, can you show a screenprint of it?
Can you reformat a copy of the database in Access 2003 format?