moving a record from one form to another?

[jonny524]

hi, i was just wondering if anyone could help me, i need to know if it ispossible to make a button with a macro that it is able to move a record from one form to another just using a button??, if anyone could help this would massively help
cheers

 

[Oldsoftboss]

Do you mean one form to another, or one table to another. Remember forms are based on tables, so you should be able to display the data any way you like.
Give the macros away and used VBA.
A simple on click event procedure would go something like
Docmd.OpenForm "SecondFormName",,,"CilentID = " & Me.ClientID

Just substitute the name of your form and criteria.

Dave

 

[jonny524]

ok cheers mate, i'll try this then, and then hopefully thi will workin the exam thanks again
sorry i dont really understand the code, so is this what i put in when i create a macro?? then so do i put in the name of the form that i want a record to go into in the SecondFormName ? but then what would i put into the client ids bit if its a whole record tat i want to move?

sorry if this sounds really dim but the help is much appreciated