Hi guys, this is the first time i am doing any web development. I hope you can help me about this. The problem is bellow:
I have a user table with the fields show bellow
Say tUser(UniqueName, F_Name,L_Name, MI...)

I want to create a data entry form which will contain UniqueNAme fields (along with other fields). I have to get data of the UniqueName from this table (access database) when the form loads in the drop down/list/combo box. I know just simple insert/update and deletes but i have not done this before. Can any body help me how can i do this.
I will appreciate your help
thanks :)

Is UniqueName a text field? If so, it is not unique. There is every possibility the same value may be inserted more than once (unless you do a check on the table before insert - not ideal, there are easier ways to achieve uniqueness)

I would create the table like so:
1..ID = int (set to primary key and auto incriment)
2..UniqueName = varChar (do you need this field?)
3..F_Name = varChar
4..L_Name = varchar

Having a true unique field is very important in most cases. Even if you think you dont need it, incude it anyway. As it is auto incrimenting, there is no need to populate it when inseting and updating.

AnyHow to show the details in a comboBox:
<%
'get records
sql = "SELECT id,UniqueName, F_Name,L_Name FROM tUser;"
'populate record set
set getInfo = conn.execute(sql)
%>

<select name="someName">
 <option name="selectAValue">Select A User From The List</option>
<% if not getInfo.EoF then
      do until getInfo.EoF
         response.write "<option value=" & getInfo(0) & ">" & getInfo(1) & "</option>"
         getInfo.moveNext
      loop
   else
      response.write "<option value=NoValues>No Records Found</option>"
   end if %>
</select>

The above combo box code will produce a list containing the 'ID'[getInfo(0)] field as the value for each item and show the 'UniqueName' [getInfo(1)] as the text string value for selection

Alternativly if you don not wish to create an 'ID' field in your table and wish the value being passed along with the visible text value of each item in the list to be 'UniqueName' :

Change This:
sql = "SELECT id,UniqueName, F_Name,L_Name FROM tUser;"
To This:
sql = "SELECT UniqueName, F_Name,L_Name FROM tUser;"
AND Change This:
response.write "<option value=" & getInfo(0) & ">" & getInfo(1) & "</option>"
To This:
response.write "<option value=" & getInfo(0) & ">" & getInfo(0) & "</option>"

Wind is your friend
Matt

Thanks a lot for your help, I will try this code. Once again i appreciate your help and valuable suggestions.
Azimi:)