Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    40

    Unanswered: unwanted data change

    Hi,

    i wonder if you can help me with the following problem.

    I use listboxes to present data and allow users to select and double click a record to edit this record.

    Sample code of this is :

    1. Fill the listbox :

    Me.Keuzelijst8.RowSource = "SELECT Orders.Ordernummer, Orders.Omschrijving, Orders.Kosten, " _
    & "Orders.Opbrengst , Orders.Categorie " _
    & "FROM Orders " _
    & "WHERE (((Orders.Categorie)=[Forms]![menu_maint]![Keuzelijst0])) " _
    & "ORDER BY Orders.Ordernummer;"

    2. Doubleclick the record and open a new form to edit :

    stLinkCriteria = "[woisnr]=" & "'" & Me![Keuzelijst10] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Now the problem...

    Sometimes an other field is being altered when opening the second form.
    How can this be possible ??

    I checked the other code and there is no reason to do this ...

    Any suggestiosn are welcome.

    Thanks in advance
    Erwin
    Bye Erwin

  2. #2
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    I'm not sure if this is the problem, but you fill Keuzelijst8, and then use Keuzelijst10 for your link criteria

Posting Permissions

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