move records (1 Viewer)

is there a way by which i can move one or more records from one form to another when clicked on the 'YES/NO' button ???

thanks in advance.

guys cmon please... i need this really bad.... im so desperate that im ready to kiss your feet...

plz plz help me .............. (pleading)

plz guys... if i dont get this by monday, i will fail my project exercize... A BIG ZERO on my report... .. so please have pity...
here is my problem

My project is about Car pooling system.
Now i need to create a form , that has 2 buttons, this will open 2 forms:

1. Car check in
2. Car check out.

i can manage that bit.

What i can't do is:

I have to make the two forms such that the records cannot be altered in any way, EXCEPT, using the button which might say "check out?". If clicked on this, that record should be removed from the "CAR CHECK OUT" form, and go into the "CAR CHECK IN" form. So later, when the car is returned, the user will go to the "CAR CHECK IN" form, and click on the box that might say "check out?" again, so it is de-selected, and the record will go back to the "CAR CHECK OUT" form. Im have attached a copy of my database to help you understand better.

Please help me, my life depends upon this... im litrally pleading to whoever is ready to help me...

PLASE HELP ME ...

Thanks a LOT in advance if you atleast thought about it...

please tell me if you didn't understand any bit of the above problem, plese tell me so i can explain it to you better.
thank you once again.

Why not just have a "CheckedOut" Flag, and when you press the button, it checks it off?

make a field in your table called "Checkedout" and make it a yes/no field.

Put the control on your form, hidden if you want.

On the button add the code


Then filder the two forms.

I don't see a Checked out form or a Checked in form on your database btw.

yeah i know... i ddnt create it becuz i wasnt sure...

also, thanks a lot for your thought, but it;s a little bit more complicated than that... because..

it has to work in the way that there are fixed records, and in the "checkin, checkout" forms, they have to work in the way i said earlier... ... un fortunately ..

and i dunno how the checkout flag works .. hehe