Search results

  1. I

    Transpose data from form to table

    Hi, I have a continous form that starts off with the data entered in a crosstab manner. e.x. Client Car Wash , Car Detail, Service 3 Service 4 ........Service 15 John Smith 1 2 This is how the client wants to enter their information. However, I would like to...
  2. I

    Insert a New Record at the top of a subform

    Sorry Paul, Yes, that was meant for you and thanks for your help. I really appreciate it as I do Mike's help also. Cheers Ian
  3. I

    Insert a New Record at the top of a subform

    Hi Mike, I like the idea of another subform at the top. From the code above to select the new record - How do I exclude the records and only show the new record line in the subform when I click the command button? Thanks Ian
  4. I

    Insert a New Record at the top of a subform

    Insert New Record at the top of a subform Thanks Mike, The solution you suggest allows the records to be sorted after data input. I would like the blank line for a new record to be entered to appear at the top of the subform Here is the Code for selecting a new record. Private Sub...
  5. I

    Insert a New Record at the top of a subform

    Hi, I have managed to create a button that when clicked will GetFocus and allow me to enter a new record at the bottom of a subform. However, I would like to be able to enter the new record at the top of the subform. Any Ideas? Thanks Ian
  6. I

    Get Focus on a New Record in a SubForm

    Solved I've managed to solve this
  7. I

    Get Focus on a New Record in a SubForm

    Hi, I am having trouble getting Focus on a new record in a subform. I have used the GoToSubform Macro On Activate. If I open the subfrom separately then this works. The focus is on a new Record. However, When I open my main form and then click on my subform the focus does not go to the new...
View older results
Back
Top Bottom