=Row() Formula

[JUALOP60]

Hi,

I have a combo box(Activex control) with ListRange of Payable Database, when I select a company populate address/city etc. fine, but since i have an index column to i created by adding formula:

on cell A2, =Row()-1works fine but now every time i select a company from the combo box it starts blinking, blinking looks like going every record and then it select company.

is there any way i can stop that?

thank you

 

[SkipVought]

Hi,

Your statement regarding your problem is not clear. What does the index column using the Row() function have to do with your combobox? Do you reference this data? I cannot understand what is going on.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JUALOP60]

Hi,

I have a combo box with on list name "CustLookup1" with column
A with Index numbers using =row() function so when I add a new company will also increase or assign next number.

The problem is that When I select a company from a combo box first switch to the database and start blinking like going through all records and then select the company.

and the i find some of the companies name are blank.

I didn't have this problem until i added the =row() function.

by the in the combo box i have a code to populate the name/address fields.

With Macro:

Private Sub TempCombo_Change()
'Macro purpose: To send the user to the home range
Call PopulateData
End Sub


Thank you