Ask Experts Questions for FREE Help !
Ask
    erosinski's Avatar
    erosinski Posts: 12, Reputation: 1
    New Member
    		  
    #1

    Sep 6, 2005, 08:44 AM
    Subform in datasheet view but need button
    I need a duplicate record button to duplicate records in the subform which in is datasheet view. Is there is a way to display the button on the datasheet? Or if there is an easy way to put the button on the main form?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Sep 6, 2005, 10:47 AM
    Quote Originally Posted by erosinski
    I need a duplicate record button to duplicate records in the subform which in is datasheet view. is there is a way to display the button on the datasheet? or if there is an easy way to put the button on the main form?
    Personally, I almost never use datasheet mode. I prefer the flexibility of continuous form mode.

    I would put the code in the doubleclick event of the subform's Detail band. Double click the record and duplicate it then requery the subform.
    erosinski's Avatar
    erosinski Posts: 12, Reputation: 1
    New Member
    		  
    #3

    Sep 6, 2005, 10:58 AM
    Good idea.. I use datasheet view because it is the easiest way to view the data. I have a lot of things to input in the main form as well as the subform.. it helps to have the view of all the records in the subform. I will try the double click event and see if it works well for me, thank you
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Sep 6, 2005, 03:54 PM
    Quote Originally Posted by erosinski
    good idea.. i use datasheet view because it is the easiest way to view the data. I have alot of things to input in the main form as well as the subform.. it helps to have the view of all the records in the subform. I will try the double click event and see if it works well for me, thank you
    Generally a subform is part of a one to many relation. So the subform needs to display multiple related records. That's why I use continuous form mode. You can do everything that datasheet mode does and a lot more.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Reverse Button [ 2 Answers ]

I have installed the remote control for my Hampton Bay fan. Everything works (lights, dimmer, fan, fan speed) but the reverse button. I lost the instructions. Does anyone know how to activate the "reverse button"?

Button in Microsoft Word [ 1 Answers ]

Dear Sirs, Is it possible to add a button in a Word toolbar which represents the execution of an .exe file? By clicking the button opening the program file. How? Thank you

Go to record on form button [ 3 Answers ]

I want to put a button on the form that pulls a string from a text box and goes to the unique "sorder number" in the form. This will keep my users from having to click next a hundred times to get to a record. I have no time to try and figure out the vb code so if anyone already has an idea how to...

Shower button [ 2 Answers ]

This morning I pulled the shower button and nothing came out of the shower head. Water just came out of the facet. The unit is a "WALTEC" and we installed it in 1993. I had noticed for a while now some water coming out of the facet during a shower but this time all the water came out of the facet....

View more questions Search