Double duty Combo box ? 1

[cbalser]

Is is possible to have a combo box on a form that shows the value saved in the table matching the selected record, as well as providing the other possible values in that table in the drop-down for changing the selection for that record? I have a multi-table form and would like to be able to view the current value as well as update this table via the combo box.

I am using recordsets, sql and vba, not Access wizards. Can you give me steps how to set this up? Thanks!!

 

[randy700]

If the combo box is a bound field, wouldn't it serve the purpose?


Randy

 

[cbalser]

I have done all my controls in the form with recordsets and being unbound, since so far I am accessing six different tables. I'm not sure how to add a bound control in the middle of that. I am populating the controls from the recordsets on update from initial search combo box, then after making any changes to any of the textboxes, saving all values to their various tables, all with VBA.

 

[GKChesterton]

Private Sub Form_Load()
    Me!boxCategory.RowSource = "SELECT PID_Caty, Descr_Caty FROM iCategoryFunction"
    Me!boxCategory.Requery

Can be done as above when form loads, and also revised for user actions.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[cbalser]

OK, great. Thanks a bunch!

 

[TheAceMan1]

How are ya GKChesterton . . .

Note: Whenever you write to the [blue]RowSource[/blue] of a combobox or listbox ... the control [purple]automatically requeries![/purple] This makes [blue]Me!boxCategory.Requery[/blue] not necessary ... Just a heads up ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[GKChesterton]

Thanks AceMan. I'm always on the lookout for ways to spare my users a requery!

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​