combobox with default selected value (1 Viewer)

[alain.roger]

Hi,

i have 2 tables (clients, frequencies) where in table "clients" i have a column to store ID of "frequencies" table (id, description).

in my form "FClient" i display data stored in table "clients" and i have a combobox that should display the "frequencies" descriptions, but with a frequency selected by default...in fact the one that has its ID stored in table "clients".
i'm able to display all frequencies descriptions but i don't know how to easily select and then display, as default, the frequency stored in table "client"

how can i do that easily ?
thx

 

[burrina]

Using the Property Sheet you can set the Default value to what you want.
When referring to the value in a query, remember to refer to the Column Number, it starts at o. Example: Me.cboSomeComboBox.Column(1)

HTH

 

[Gasman]

The way I have done this is to bind the combobox to the field in the client table and use a select statement in the rowsource.

If you use the wizard, it will do it all for you.

HTH

 

[Mihail]

Welcome to AWF.
Access manage itself the ID's if you will use a form (frmClients) that contain a subform (frmFrequency)