Run table make query after form input

[ACCESS NEWB]

Is it possible to do following:
On saving new records in form to force access to run table make query?
If doable would you be so kind to write me example code

 

[odin1701]

You can do something in the After Insert event in your form (or After Update - Insert I believe is just when new records are made, update is anytime you change an existing one and move to the next record).

What would be the purpose of making a table every time you did this?

 

[ACCESS NEWB]

Actually it should be done only when i enter all fields data in..
I am trying to make equipment sign in/out database,and that would give me table with available equipment .In form I actually assign peace of equipment to person and runing that query would remove that item from available ones.(I realize i cant do in form created from query all I can do with form created from table, so I want table)

 

[ACCESS NEWB]

and I would still need code because my VBA knowledge is not, hm let say ,very representable,

 

[odin1701]

Why not add a field to your table with the equipment - a yes/no field to indicate whether the equipment is checked in/out - and a field to indicate who has checked it out, etc.

Then you can make 2 queries - one to show the checked in equipment, and the other to show the checked out equipment, all just based on that field.

No reason at all to move records to different checked in/checked out tables.

 

[ACCESS NEWB]

thats exactly what I did.
Took me awhile to figure that is the easiest way ( well easiest I discover,hehe)
Thanks anyway