Hi all,

I've been asked to create something in Excel i'd much rather do in Access but been told it *needs* to be done in Excel much to my frustration!!

Essentially I need to create a userform, whereby you can add/delete records, and navigate to other records, all from within 1 form.

What i'm not sure about is how to get the information for a particular row that's stored in a excel worksheet in an access-type format into the userform?

I've thought of either
1. Creating a loop macro that picks up the listbox.index and uses that to offset the row and picks up each column and copies information into form. The problem is I need to tell it what column goes in what control. I have some 25 controls and that's a lot of hard coding!

2. Some sort of querytable that works a bit like an SQL query, but I have no idea how to do this, if it's even possible.

I'd like to be able to do it by saying "put this field in this userform control", e.g the column 'FirstName' fills the control txtFirstName on the userform. Then when you select a record it populates all the required information.

I hope i've made myself clear. Any suggestions/advice or sites you can supply would be much appreciated, if it's even possible.

Peter.M