Field doesnt save change HELP Please

[martin007]

I am new with access and need some tips. I tried to get some information by buying an access book but it didnt give me the information i needed.

I have a database with a table i just created which is called VersionSoftware this table is linked to a table Clients that already as some informations about our customer.

The table VersionSoftware is set as a primary key and i inserted some value ex: 1.0, 1.1, 1.2 which are the version of the software we are using.

On the form i have created a VersionSoftware combo box which show the information from the table VersionSoftware.

The problem is that it doesnt save itself to the Client database i have created a new field in the client database which is called SoftwareVersion.

I don't know how to create a control source i tried to set it manually but i get an error message at the bottom saying that the field is bound to an unknown expression.

If someone could help me and give me some tips on what i need to do would really appreciate it.

You can email me if you want to martinm@sirsi.com

Thanks,

Martin

 

[Gazer44]

OK, you should have the combo's row source as 'table VersionSoftware' (that's where the drop down fields come from.)

Then set the Combo's Control Source as the 'SoftwareVersion' field (this field should be on the Forms Record Source Table/Query)
The Combo's Control Source is where the combo's field is going onto.

 

[martin007]

When i scroll into the control source i dont see SoftwareVersion it isnt there i dont know how to do that part.

 

[WildHare]

The easiest way to do this is in Table Design. Go to the field at your customer level that contains the Version Number. CLick the LOOKUP tab on the properties sheet for it. Set the ROW SOURCE type to Table/Query, and the Row Source to your Version Number field in the VersionTable table. Make this field a COMBO BOX display type.

Save the design change.

Now, when you enter this field at the Customer Level, you'll have a combo box that contains all the values in the VersionNumber field over in the VersionTable table. Make a pick, and you're home free.

Saves a lot of grief back and forth.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[martin007]

I did the change went to set the row source the problem is that it doesnt save the change to the client table in the field i created i do not have a control source set cause it always give me unknown expression bound..

 

[martin007]

Now in my combo box when i look at my form i have #Name? When i select a version number i get this error:

Control can't be edited, its bound to unknown field...

 

[Gazer44]

OK, does the Table - VersionSoftware only have the 1 field in it (version) & is this field only used for the drop down menu.
If so then you don't need to connect this table to the Clients Table.

Create a query from the Clients table containing ALL the fields which should also include a field called 'SoftwareVersion' - which is where the combo's info will go.
(one or more of the fields on the query can then be set at 'ascending' if necessary so the results are in order)

Set the Form's Record Source as this query. Then set the Combo's row source as the table 'VersionSoftware' (so it picks up the values 1.0,1.1 etc.)

Set the Combo's Control Source as 'SoftwareVersion' field.(this is the field on the query where the combo's info is going to save to)

this should work

 

[martin007]

The VersionSoftware table contain one field which is set as a primary key this field contain all the version number. The field is called VersionSoftware also.

I don't know how to create a control source could i get some help or information on how to do it?

 

[martin007]

The VersionSoftware table contain one field which is set as a primary key this field contain all the version number. The field is called VersionSoftware also.

I don't know how to create a control source could i get some help or information on how to do it?

 

[Gazer44]

You don't have to 'create' one. Just go into the design of the form and into Properties (right click on the small box-top right of the form-select 'properties')

Then click on the combo box- within Data tab you'll see 'control source'. (This is the field on the form you want to save the combo info to) In your case it's called 'VersionSoftware'. If this field is not in the list then it needs adding to the Table or Query that the form is looking at.

Once this is selected it should work.

 

[martin007]

How can i tell what table or query a form is looking at? Cause the field isnt there.

 

[martin007]

Thanks Gazer44,

Im really happy i finally got to do what i wanted to do thanks a lot for your help i didnt know the form was linked to a Query.

I looked arround and finally got to select the control source and everything is working fine.

Thanks to all those that gave me a hand !

Later

Martin

 

[Gazer44]

Good, glad you got it sorted.
(p.s. to go into properties you right click on the small box-top LEFT of the form & select 'properties', not top right as i said prev.- type error)

cheers