UserForm question

[maximus73]

I need to get some values from an Access database and place them into
a worksheet. I am thinking the best way to do this would be to create
a user form with a few controls (combo boxes) that would allow them to
pick the different items they need from the Access database (a job
number, and a status option). They would then click OK on the form
and the appropriate fields would be populated on the worksheet. Does
this sound like the best method to accomplish this? I have started
creating a userform with one combo box to lookup the job number but it
is not listing any data.... the code I am using is below: THanks!

Please Login or Register  to view this content.

[royUK]

you can set up a database Query instead of VBA.