Straightforward problem

[ed1967]

Hi

I'm sure this is a fairly straightforward problem, but it's not something that anyone's been able to help me with, and I've not been able to find it in any of our reference books.

I'm adding a new Combo Box to an existing form in a database. However, when I set the Combo Box up, one of the steps that usually appears in the wizard is missing, and it's probably the most vital one...the step that asks you where you want to store the selected value from the combo box. Does anyone know why this is happening (or not happening!?)

(We use Access 97).

Thanks for any help.

Ed

 

[CameronM]

If you have not bound the form to a Record Source you will not be prompted by the wizard to save the value in a field (because it doesn't know what fields you can save to).

Make sure your form has a valid Record Source, either a Table or a Query and then add the combobox. If you have already added the combobox and need to save it to a field in the Record Source, then you will need to set the Control Source property of the combobox.

 

[ed1967]

First, sorry - I put this in the wrong area.

Second, Cameron M, thanks for the reply. The problem I have is that the form is unbound and the whole database was created by someone else who is no longer here to ask!

 

[CameronM]

If the form is unbound, then you will not be prompted to store the combobox value in the database.

You can still use the combobox value by using Me.[NameofComboBox] in you VBA code, or as a criteria in your Queries by referrencing the combobox. Just select the 'Build' option from query popup menu (right mouse click in the Criteria field of the query design screen). You will end up with something like Forms![FormName]![ComboBoxName] as the criteria for your query.

Let me know exactly how you want to use the value from the combobox and I will try and give you an example.