Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User form for selecting rows
- Thread starter GoGz
- Start date
littlewoman
Programmer
I'm only a beginner but I did it like this
On a worksheet you have your accountnrs in a column
On your form you put a combobox
fill this combobox in the userform.activate event with these accountnos.
put on the userform all the textbox fields you need to display the data you want.
then in the afterupdate event of the combobox use the value choses with the .find method to get the data from your database associated with that accountno. and fill the textboxes on the userform with those values found.
it worked for me.
On a worksheet you have your accountnrs in a column
On your form you put a combobox
fill this combobox in the userform.activate event with these accountnos.
put on the userform all the textbox fields you need to display the data you want.
then in the afterupdate event of the combobox use the value choses with the .find method to get the data from your database associated with that accountno. and fill the textboxes on the userform with those values found.
it worked for me.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Solved
- Locked
- Question