Insert data from previous row

[mad-q]

Hello

I recently found the shortcut CTRL + ' will take the information from the field above and insert it into the next row. But I want to take information from the previous row but different column and insert it into the selected field in the next row down.

So for example
Part Number Alternative
001 002
002

Yours
Iain

 

[GinaWhipp]

Maybe this will help...

http://support.microsoft.com/kb/101081

 

[missinglinq]

Assuming that you want the Value from the Alternative Textbox, from the previous Record, to be placed in the next Record's Part Number Textbox, you can use the AfterUpdate event of Alternative to set the DefaultValue for PartNumber. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new Record.

Private Sub Alternative_AfterUpdate()
   Me.PartNumber.DefaultValue = """" & Me.Alternative.Value & """"
End Sub

Linq ;0)>

 

[mad-q]

Hey, thank you very much for that but I was hoping I could get it to do it by user request. It is the case that if we haven't got a 001 we can offer a 002 to the customer and the user then presses a button / shortcut and it takes the 002 and puts it in the next row down.

Thanks

 

[mad-q]

Hello
Thank you for that, I have got it to work and even best when the user has to double click on the cell to transfer the data to the relevant cell. The only thing is that Access doesn't recongnise the text in it as text. You have to either type over it or copy / paste. The main reason is that it then selects the relevant data for the rest of the table. Like part number description and part number price.

Any thoughts would be most appreciated.

 

[mad-q]

Sorry if the above isn't that clear. Access displays the text as a suggestion, you then have to either type it in or copy and paste then Access will reecognise it.

Thanks

Could there be some other code I could use as an event procedure to accept the suggestion???

 

[GinaWhipp]

Not that I can think of, perhaps Linq will pass by with another thought...