criteria to select only the active record on a form for an append

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im trying to append data from a form using a command button. i already saved
the data to a main table,but when i push another button i want the currently
displayed record to save to a certain table, depending on which button i
push. right now im using an append query, but the criteria i use now always
prompts me to enter a "parameter value". the criteria box now reads
[prisoner id?] but i want it to automatically save the currently active
record to the new table. if this makes sense, and anyone understands what i
am trying to do, please help. if it doesnt make sense, please say so and i
will try to clarify.
 
hi,
tell us about the your form. i assume it's bound. is it
datasheet view, form & subform, other?
 
[email protected] said:
hi,
tell us about the your form. i assume it's bound. is it
datasheet view, form & subform, other?
Click to expand...
i dont know if it is bound or not. dont know what that means. really dont
know much about access at all. i just started working with access about two
days ago. sorry. the form opens in form veiw. i can tell you the form has
boxes for data entry, then on the right side there is a save button. after
that, you have two command buttons for two different options: inside or
outside. ive linked the "inside" button to a macro, that opens an append
query, that i want to append the record that is current on the form from one
table to another. i just confused myself. ok. it works, but the problem i
have now is that every time the append query runs, it asks me for information
before it appends the data. what i want it to do is take all the data from
the form i just saved, and put it to another automatically. did that help?
if not, ill try to elaborate more. thanks for your interest.
 
for some history, im trying to build a database to track a prison. it has
to be able to add new prisoners, move prisoners from cell to cell, cell to
tent, tent to cell, segregation to cell, etc. i also have to be able to
release prisoners when their time is up. it works ok right now, but i want
to make it very user friendly, cause there are people working the prison who
dont have a lot of brainspace. i have had no problems except for figuring
out the right criteria for the earlier stated problem. i have no training in
using access, just kinda figured out what i need to do, but that damn visual
basic is killing me. so is the criteria for the queries. any help you guys
give will be greatly appreciated by not only me, but the rest of the 194th
Military Police Company, Mosul, Iraq. thanks.
 
AASLTMP,

If your 2 days into Access there is quite a lot to learn, as a newby myself,
Ive learnt a lot over the last few months thanks to other people's
contributions in this forum. Do a search in this forum for "Free Access
Training" (12/10/04) which will take you to one of my posts that a guru (1 of
many) in access called Jeff Conrad, who answered with a wealth of information.

In the meantime, to check if your form is "bound" or "unbound" (linked to a
particular table/query) open the form in design view, double click on the box
on the top right of the form between the scroll bars to get the form
properties, and then look under Data for Record Source, if blank I think that
mean its unbound. If its bound then the items (Controls) on the form will
default to whatever the form is bound to.

Lastly I dont know enough to answer your question, but although it looks
almost impossible when you start, when you do achieve results its very
rewarding, and your aim of making a database that is easy to use is key to
gaining quality data,

Cheers Tim
 
Back
Top