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

[martin007]

Hello Everyone,

This might be a very basic question i will explain what is my problem and the work i did so far.

I have a database that as all the information on our clients which operating system they are using which softwares they use and more...

I created a field for a new software that my company is selling we have arround 10 programmers that dont even know access so i am really hoping to find a solution.

What i need to do is simple make a table that will have every software version that we are using example:

SoftwareVersion: 1, 1.1 ,2.0

Another table which is already made where i created a field called nameofsoftware. That field should be a unique field for every client and would save the current version into the appropriate field.

I have made a combo box on a form and i was able to make the combo work to be able to select the SoftwareVersion content (1, 1.1 ,2.0) the problem is that in the field theres a #name? sign into the combo box and when i select one of the version number it doesn't update itself into the client table into the field nameofsoftware.

I get the error Control can't be edited, its bound to unknown field

 

[WildHare]

Martin, did you make the Clients-side NameOfSoftware guy a lookup field like I suggested in another thread? This is really the simple, foolproof way to do this.

You're getting this error message because the COMBO BOX as you have it should NOT be bound to a particular field. It gets its contents from the SoftwareVersion table, but when you make a pick, you want to assign that selection to the NameOfSoftware field in your CLIENT table:

Sub MyCombo_AfterUpdate
me.NameOfSoftware = me.MyCombo
End SUb

This is assuming that NameOfSoftware is a field in your form's recordsource.

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

 

[FoxProProgrammer]

Hi,

You need to add code to the After Update event of the combo box that searches the table for the record and displays it in the form. You would do this with a Find Method, and setting the Recordset Bookmark to the Form's Bookmark if a match is found. dz
dzaccess@yahoo.com

 

[FoxProProgrammer]

Sorry, Jim. We must have been typing at the same time. ) dz
dzaccess@yahoo.com

 

[WildHare]

I thought I heard an echo..

I think Martin's problem is that he's BINDING the combo box to his LOOKUP table, and not doing the step to actually TAKE the value selected and stick it in the CLIENT side table.

--------------------------------------------
This can be very confusing to many people, since you can use a COMBO for two different purposes: Displaying a LIST of records, and POSITIONING to the record that matches your choice, (This is choice #3 in the combo box wizard off the toolbox, on a bound form) or displaying a list of VALUES and posting the choice made to a FIELD in a(nother) table.

Combos can have VALUE lists, hard-coded entries, or they can be based on queries or tables for their contents. What you do after you make the pick from the C-B is up to you.

-------------------------------------------

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