Control can't be edited - Bound to autonumber field 'field name'

[scouser]

I am receiving error: "Control can't be edited - Bound to auto number field 'field name' "

I have attached scaled down sample database (Access 2003 format). The Form(s) ENTRY_SOFTWARE_LICENSE_FORM & ENTRY_SOFTWARE_LICENSE_SUB_FORM are supposed to allow users to enter a License Key for a Product.

ENTRY_SOFTWARE_LICENSE_FORM. When user selects from combo 'cboSupplierID' label Vendor the combo 'cboProductID' label Software Description updates to display products related to the supplier. However I am unable to select from the combo as I receive the error?

Originally I had a separate table for software but now all software is listed as a supplier product.

I have recently redesigned the database and this is the only bit I am unable to get working!!

When complete I will post finished 'Audit' database to this form for others to benefit from.

Your help on this issue as always very much appreciated.
Kind Regards,
Phil.

 

[namliam]

Your sample DB is missing " qryLOOKUP_OPEN_LICENSE_ID "

I cannot find any 'cboProductID' on your form, but am experiencing the problem with the combobox Description.... (productDescription) I guess that is what you are looking for.

AHA!

I found your cboProductID and raise you my ProductDescription.

You can change the Combo, but it is invisibly HIDDEN behind said text field ProductDescription....

Sometimes its these stuppid little things, that you just cannot seem to find.

 

[DCrake]

Simple Software Solutions

Two problems

Take out the bound field ProductID from the Combobox

change the master linked fieild to cboProductID

 

[scouser]

Bound Field

Hi. How do I remove the bound field? What should I do to get it working? (start again!!).

 

[namliam]

what you think is your combo box is actually 2 seperate fields.... one on top of the other.

In design view, click on your "arrow" of the combobox and drag it away, now you see you have 2 fields.
Simply remove the one you dont want...

 

[scouser]

Hi

Hi there was a reason for that originally. After selecting supplier then product the product description used to dissapear (i.e. cmboProductID bound field 1 2 columns 0;6.

I think I will start again. Basically I want a form where users can select supplier & products supplied by that supplier then enter license details (if software). However after redesign suppliers can supply hardware /software etc... the old design held software in a seperate table. I have added category table so I can filter on 'Software' (or whatever!!).

Thanks for your time.
Phil.

 

[namliam]

then your "after update" code of the combobox is broken.... or non excistant or... missing?

 

[scouser]

Bound

I did not give an accurate reason for the form layout! The Productescription field was added to display the ProductDescription after the user selected the ProductID related to the suppliers selected from SupplierID. Without this the field displayed the ident number (ProductID) of say 55.

My improvements have not had the desired effect!! I will start again regards this functionality.
Many Thanks,
Phil.

 

[namliam]

"all" you need to do is " on update " of the combobox do this:
Me.YourTextbox = Me.YourCombox.Columns(7) 'or what ever column you have your data in.

This IMHO is one strange requirement.... one that can only come from the liverpool (right?) area!!!

 

[scouser]

Bound

Ha! Ha!. My dad is from Liverpool, I am a southern softy! I have redesigned the form (removed the combos that once were). Users can now search by supplier product where the supplier product category = software. They can then add a license........may not be perfect but it works.
Thanks for your efforts.
Phil.