Adding a list to an existing form

[esuccj]

Hi,
Im trying to add a drop down list to an existing form. I set up a table with the options i want the list to refer to and then select this table under the list option when under design view.
I tell the wizard to place the data under another table, but when I close it from design view it is not possible to select one of the values from the list.
Is there anyway I can get it to select one value and store this in a table?

Thanks !

Warren

 

[dt01pqt]

Have you bound the combo to the table you want to enter in? What does it say under the form's properties for allow edits and allow additions?

 

[Mile-O]

Also, don't use a table as a RowSource for a combobox.

Base a query on the table, selecting only the fields you need, and sorting the relevant field(s) accordingly. Save the query and set this as your form's RowSource.

 

[dt01pqt]

Also, don't use a table as a RowSource for a combobox.

Base a query on the table, selecting only the fields you need, and sorting the relevant field(s) accordingly. Save the query and set this as your form's RowSource.

Or you could type it in as text if you only have a few options and it is not going to change much.

 

[Mile-O]

it is not going to change much.

Much or not at all?

 

[esuccj]

Hi

Thanks for the replies,
Im not sure where you find the properties for allow edits and additions under the form, as when I right click I and select properties I cannot see this under any of the options I select.

Cheers
Warren

 

[Mile-O]

Have you set the combo's ControlSource to the field you want to store the data in?

If there's nothing there, check the form's RowSource. This should contains a query of the table you want to store the info in.

The AllowAdditions, AllowEdits, AllowDeletions properties are on the Data tab of the form's properties - I would doubt this is your problem though.

 

[esuccj]

Some tuition?

Hi,
Tnxs for the replies!
Could some one explain about Rowsource is, where it can be found etc!
This is new to me!
Warren

 

[dt01pqt]

Much or not at all?

As long as you cap the total string length it doesn't matter if it changes. You have to have a good reason for doing that way though. Can't deny that I have done it this way to save code.

 

[Mile-O]

Could some one explain about Rowsource is, where it can be found etc!

It's a property of either combobox or a listbox in much the same way that the ForeColor or the Font is a property of an object.

You can find it on the properties sheet of a combobox or listbox.

Once you find it, put the cursor over it and hit F1 - that will tell you all you need to know about it.

 

[dt01pqt]

Hi,
Tnxs for the replies!
Could some one explain about Rowsource is, where it can be found etc!
This is new to me!
Warren

Warren when you used the wizard it asked you what table you wanted to reference from i.e. to be the dropdown list of the combo box and the table you wanted the result to be entered into. RowSource is a property of the combobox and you can set manually by right clicking on it and selecting properties it should be under the Data tab as is the RowSourceType, which should be set to table/query if you want to reference a table or query.