Search results

  1. B

    Solved Updating an unbound field after updating a bound field

    I'm just trying to have an unbound field [ProviderCheck] value update based on the what is entered into another field [Provider]. I keep getting a Type Mismatch Error. I've tried to change the format of the unbound field, but that hasn't worked. I'm sure I just have some type of syntax error...
  2. B

    DLookUp syntax problem

    I want to return a value from a separate query and have that show up in a field on my main form. The field name from the query is "Six Month Date" and the query name is "DT6Monthqry". I want to return the value displayed in the"Six Month Date" from the query, matching the CustomerID in the...
  3. B

    stLinkCriteria with date field

    I'm getting a syntax error with the following string: stLinkCriteria = "[Injury_No]=" & Me![Injury_No] & "'And[RehabDate]=#" & Me![RehabDate] & "#" Can anybody tell me where I messed up? The field "Injury_No" is a number and "RehabDate" is a date field. I know with a date field the syntax...
  4. B

    Adding new records with filtered data

    I have an Access form that I am having trouble assigning a specific value to a field in that form. I have mostly used the wizards to create a lot of my forms, so I only have minimal experience with VBA coding. I will try to give the clearest picture on what I’m trying to do. From “Form1” I...
Back
Top Bottom