Search results

  1. G

    Default Value in a Form

    Hi I am having some difficulty with the default value in a form. I would like it to be the value in the previous record. I have been using DLast, but for some reason it doesnt seem to work for some of my fields. For the field "Station" it works but for the field "Field Officer" it returns an...
  2. G

    Using an Append query, but not adding duplicates

    Hi, I would like to use an append query that appends data from a union query into a table, but doesn't add duplicates based on a certain field. I have been trying to use this code, but it doesnt seem to work. INSERT INTO [Cotton13/14] SELECT DISTINCT [Contracted Farmers].* FROM [Contracted...
  3. G

    Form that creates a new record in a different table

    Hi at the moment I have a form that uses a text box to search for a specific record in a table.(Cotton12) This works perfectly. What I would like to implement however is if the user so wishes he can edit the data he is shown, whithout editing the actual data in cotton12 and then with this new...
  4. G

    Using a Query Within a Form

    Hi I have a form that has a text box in the header and when the user enters the farmer Code into the text box the relevant record is displayed. I am using the following criteria in the query within my Form Cotton12: Like [Forms]![Cotton12].[2012] Now I have 2 tables Table Cotton12 and Table...
Back
Top Bottom