combo box disable edit (update)

[jheacox]

I am new to Access 2007, and I am having dificulty with the combobox properties in my form.



Let me explain: I have created a form with a subform. The main form consists of one field displayed in a combo box, when an item is selected from the pulldown the subform displays it's info.

The problem is when I select an item from the combo box pulldown it is assumed that I want to update the db field. The little pencil comes up, and I get a pop-up with an error because the db field is defined as a unique. Cannot insert duplicate key yada, yada, yada.

How do I disable the edit feature on the combo box?? I have tried setting all of the different properties, but none of them seem to disable the edit function. I really don't want to write any VB code or macros - Is there an easy solution to my problem?

[RuralGuy]

Simply remove the ControlSource of the ComboBox.

[jheacox]

If I remove the Control Source then the subform does not get populated. Essentially it can't query the db if it doesn't have a ControlSource.

I also have a query in the RowSource "select column1 from table1".

Do I need to have the Row Source defined?

[RuralGuy]

How about posting your db so we can look at it?

[jheacox]

Sorry can't post db, but basically there are 2 tables used for my form.
=========================================
Table1

Hosts - which is just a list of hostnames

Table 2:

FileList by hostname (fk to the Hosts.hostname table): 1 - many relationship
============================================
Form combobox queries hosts to populate the subform that has the FileListing.

The navigation buttons at the bottom work fine, and the combo box value changes with the buttons. It only tries to update the Hosts table when you use the combo box pulldown to select a host.

I created the form using the Forms Wizard. Then changed the Hostname text box to a comboBox so the user can pulldown the hostname from a list.

[RuralGuy]

TRy putting a new ComboBox on the MainForm with the wizard and select Option #3. If the LinkChild/MasterFields properties are completed properly, it should do as you want.

[jheacox]

The combo box works fine now with option 3, but now when I use the navigation buttons at the bottom the subform changes but the comboBox doesn't. How do I link the navigation buttons with the new combo box?

[RuralGuy]

The new cbo is just for moving to a record and is unbound. You could use the Current event of your form to set the value displayed by the cbo if you want.

[jheacox]

Sound like a plan. How do I do that? Remember I'm a novice.

thanks for your help so far.

[RuralGuy]

Your code will look something like:

Private Sub Form_Current()
 
   Me.YourComboBoxName = [TheFieldYouWantDisplayedInTheComboBox]
   
End Sub

Using your values for the items in RED.

[jheacox]

Thanks, that worked. How do I set this as solved?