List box changes values for all entries

[Guest]

Hiya,

I have read similar queries to this but couldn't quite figure out the
response!

I am setting up a basic database of clients details, and would like to
include a list of their current status. I have set up a field to do this and
specified the different options for the list. The problem is when I go into
the form to select a value for one client, the details change for all clients!

I am fairly new to Access so would appreciate it if any responses took this
into account! I.e. talk to me like I'm stupid!

Many Thanks

 

[Guest]

Is your list a combo box? If so, you likely need to include a status field
in your client details table as a Control Source. Open the form in design
view. Click on View > Properties to display the properties dialog, if it is
not already displayed. Select the Data tab. Click on the control in question.
You should see the name of this control in the blue title line of the
properties dialog. The first property on the Data tab should read Control
Source. This property specifies the field that you want to use to save the
selection that a user makes. The value that is saved corresponds to the bound
column property. The data types must be the same. If the bound column is
numeric, then the Control Source must be a numeric data type. If the bound
column is text, then the Control Source must be a text data type, etc.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________