Command Button to Add Next Entry With Some of the Same Data 1

[mcongdon]

Hi Everyone!
I have a form, frmNewTicket, that I would like to add a command button to. Right now, everytime someone goes to add the next entry, they have to re-enter a lot of data. I would like to add a button that will bring up the form for the next entry, but automatically fill in some fields with the same data as the previous entry. For example the form would look like this:

TradeDate SettleDate CUSIP Account#
5/1 5/2 HGL 4444

I would like to click a button here and have it advance to the next entry, but already have certain fields filled in. In this case the TradeDate, SettleDate, and CUSIP. Account# is left blank to be filled in.

TradeDate SettleDate CUSIP Account#
5/1 5/2 HGL

Thanks for any help!

 

[Remou]

You can set the default value of the control before moving to the next record:

[tt]Me.SomeTextControl.DefaultValue = "=" & Chr(34) & Me!SomeTextControl.Value & Chr(34)[/tt]

 

[Remou]

Do both you and Panchdara go to the same school?

 

[mcongdon]

Would this make it copy over every time? There is only a need for this feature about half the time, the other half the end user wants to have all the fields empty.

 

[mcongdon]

No, this is for my work- I've been working on this database since March. I graduated last year and I currently work for a investment firm.

 

[Remou]

You mentioned a button, you can set the default values if the button is clicked and clear them in the current event.

 

[mcongdon]

Thanks Remou, works beautifully!