Search results

  1. L

    First record changed when filtering subform problem

    Hello, I have a form in access 2007 that filters two subforms within it by a date. The idea is that when you change the date on the main form you can start data entry into the subforms. When you initially open the form a specific date and it's filtered records (already in the database) are...
  2. L

    How the forums work?

    Hello, I am new and don't know all the rules of forums, thus I thought I would clarify something within this forum before making another faux-pas! I have found a thread written a year ago with no replies, but from someone who looks to have had the same problem that I am currently dealing with...
  3. L

    using subquery to select top n records isn't working

    The SQL statement I am using is - SELECT [2010 chicks rung].bird_id, [2010 chicks rung].nest_rear, [2010 chicks rung].date, [2010 chicks rung].time, [2010 chicks rung].weight_g FROM [2010 chicks rung] WHERE [2010 chicks rung].bird_id IN (SELECT TOP 4 bird_id FROM [2010 chicks rung]...
  4. L

    ComboBox to search subform and allow data entry

    Hello, I am trying to create a combo box in the main table that allows me to search and select, bringing up related records in my subform. When I have made a combobox using the wizard, it has all the values from the field and you are able to search through and select. However, the subform is...
Back
Top Bottom