Search results

  1. T

    Form/Subform - populate subform with form data help

    I have a main and a sub form that I am working with. I have a date field on the main form that I want to be displayed on the subform without the user having to enter it for each subform line. I have coded the "Oncurrent" event for the subform with: If Me.Newrecord then...
  2. T

    Form Eval Not Working

    I am having trouble with code that has to be a simple error but I can't determine what it is. I have a form that is linked to a query with one field. I want to evaluate that field and if it is null, perform an action and if it is not null, perform another action. The query and linked field on...
  3. T

    To AutoFill or Not To AutoFill

    This should be about as simple as it gets, yet I can't determine how to do it. I have a table with form that I want to enter data. The fields in the table are: Invoice, InvoiceDate, & Amount. The Invoice and InvoiceDate will be the same for 50 or so entries. On a form, how can I just enter...
  4. T

    How to Reference an Expression in same Qry?

    I have an expression that I am trying to reference as criteria in the same query. Is this even possible? I think I know how to do that with a form and unbound textbox but if there is an easier way inside the query, I would rather do that. The SQL is: SELECT [Enter Qtr] AS Qtr, [Enter Year] AS...
Back
Top Bottom