Pull records from Database using Excel userform

[cken21]

Hi,

I have a userform which records a range of Data onto an external database table. I was wondering is it possible to retrieve these records one at a time into textboxes on another userform based on a condition. I know this seems vague but i can't find a solution using google or VB forums

Date
Product Number
Surname
Incentive Paid: Yes/No

Ideally this would run off a command button which would then retrieve the next record which meets the criteria

 

[SkipVought]

hi,

You can query your data, either use MS Query, which is a native Excel feature via Data > Get External data... or using ActiveX Data Object via VBA.

Skip,

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