Access VBA

Resolved · Low Priority · Version 2003

Fri 23 Oct 2009, 09:40 Fabian (guest) said...

Access VBA

If I have an integer variable based on a value from a combo box and that value consists of two columns, both integers how to decide which one to take?

Fri 23 Oct 2009, 10:03 Trainer Stephen said...

RE: Access VBA

Hi Fabian

Thanks for your question

I am assuming that you are selecting a value in a multicolumn combo box and assigning the value of that combo box to a variable.

If this is the case then the value of the combo box is always the first (left most) column in the combo box. The other columns are there to clarify the identity of the field to the user.

Thus, which ever column you wish to return must be set as the first column

Regards

Stephen

Thu 29 Oct 2009: Automatically marked as resolved.

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips

Access VBA

Access VBA

RE: Access VBA

Access articles

Access tip:

Change case