Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access vba

ResolvedVersion 2003

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?

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:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.