Combobox Display Question

[Keepontrying]

Using the combo builder I have enter in a list of choices. I select a field in a table to store the result.

Now I enter a new record and save it. Return to edit the form and I notice the combobox is not displaying the data store.

I figure that part of my problem is because the combobox is being populated with the list of choices and not the data field. So how can I display the store selection??

Thanks again

John

 

[puruawade]

John,

I guess when you return to the edit form you are editing the existing record which you just entered. Also other objects must also be displaying the values of the fields in that record.

If this is true, in the event which takes you to edit form add this routine -

STORE fieldvalue TO ...yourcombo.value

This way it will show the stored value. User can of course change it.

Puru

 

[Mike Lewis]

John,

Could you tell us the contents of the following properties:

ControlSource
BoundColumn
ColumnCount
RowSource
RowSourceType

That might clarify the problem.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[Mike Gagnon]

Keepontrying

Return to edit the form and I notice the combobox is not displaying the data store.

One situation that could cause this is that both fields, the one that populates your combo and the one where you store the selection, have to be the same type and lenght.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.