retreiving MS Access data into forms

Results 1 to 2 of 2

Thread: retreiving MS Access data into forms

  1. #1
    Join Date
    Dec 1969

    Default retreiving MS Access data into forms

    I am designing an update-form to amend profile information in a MS Access 97 database. In order to retrieve the existing values into the form I am using the string <%=Session("xxxxx")%> as the initial value of the field. This works fine with single line text boxes and displays the existing database values as required. However in the case of scrolling text boxes the actual string itself is displayed in the box (and saved to the database if I submit the form). With list boxes the first item in the list is displayed. How can I overcome this and get the existing database values into all form fields?

  2. #2
    Join Date
    Dec 1969

    Default if i understand correctly...

    which i normally don&#039;t, I&#039;d use a an array of list items in the session instead of using a string.<BR><BR>You can do this:<BR><BR>session("foobar")(0) = "item1"<BR>session("foobar")(1) = "item2"<BR><BR>etc<BR><BR>hope that helps<BR><BR>JT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts