An easy one for you

[helphelphelp]

HI

I do not know what I have done but I am banging my head against the wall, I have three tables in this recruitment db im making and I have a problem that I know is so simple but is killing me off.

In one of the forms (add new vacancy) it has a drop down box that selects the name of the company from table called (company main) within the company main I have two columns (company) & (company no).

now back in the add new vacancy form I have a box that should collect the informtion of the company no whenever I select the company from the drop down list, but you guessed it, its not finding the information please help before i go mad.

 

[ShaneMan]

HI

I do not know what I have done but I am banging my head against the wall, I have three tables in this recruitment db im making and I have a problem that I know is so simple but is killing me off.

In one of the forms (add new vacancy) it has a drop down box that selects the name of the company from table called (company main) within the company main I have two columns (company) & (company no).

now back in the add new vacancy form I have a box that should collect the informtion of the company no whenever I select the company from the drop down list, but you guessed it, its not finding the information please help before i go mad.

In the After Update event of the cboBox have you tried putting:

Me.TextBoxName = Me.cboBoxName.Column(WhateverColumnCompanyNoIs)

remember Access starts counting columns at 0 so if it's the second column the Column number for CompanyNo would be (1)

HTH,
Shane

 

[helphelphelp]

Nearly there

Hi
I did as you said and thanks very much I am starting to retrieve the information but the column No does not seem to be working, the information the text box is now just showing the information that is in the combo box I have tried all column no's and like I say they are either showing the company list or blank.

Thanks for all your help..