Access Newbie Question.

  • Thread starter Thread starter Eddie Allen
  • Start date Start date
E

Eddie Allen

I have a quick question.. This maybe the wrong way to think about this but
here it goes.

I have a Form that is made from a query. My problem is that when u input
info into the form it stays in the query and does not get added to the table
from which the query is based on. Is there a way to make the query and the
table the exact same info. Say that I added some info in the form and it
automatics syn. with the table?

Thanks

Eddie
 
Eddie Allen said:
I have a quick question.. This maybe the wrong way to think about this but
here it goes.

I have a Form that is made from a query. My problem is that when u input
info into the form it stays in the query and does not get added to the table
from which the query is based on. Is there a way to make the query and the
table the exact same info. Say that I added some info in the form and it
automatics syn. with the table?
Click to expand...

Neither forms or queries *store* data. If the form is bound to a query then
data that is saved will be saved to the source tables for that query. It
couldn't possibly go anywhere else. You're not by any chance attempting to see
it appear in the table as you are typing are you? If you make the entry, save
it, and then open the table, you will see the data.
 
Ok, I guess I have a problem. There are phyically dif info in the query and
the table. So I assume the query is unbound correct?

Eddie
 
Eddie Allen said:
Ok, I guess I have a problem. There are phyically dif info in the query and
the table. So I assume the query is unbound correct?
Click to expand...

No such thing. A query is nothing more than a selective view of data in a
table. You can apply formatting or use expressions to make the output of the
query "different but based on" the data in the table, but any data that is
entered via a bound form will put the data in the table and nowhere else.

Perhaps if you explained how the data is different in the query vs. the table or
gave some examples.
 
Srry, I was looking at the wrong table......lol....long day......
However is there a good FAQ on setting up security for access.
I would like to only allow 1 user to access the database at a time?

Eddie
 
Back
Top