entering data into forms

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

hello everyone. Havent worked in Access in a while and ran
into a pretty simple problem. here it goes.
I have a access database with 3 tables. these tables are
linked by "user name" field. i have created a form with
all fields from all 3 tables. everything works fine but i
am not able to edit or add records. does anyone know what
im missing? ive have went though all settings but am not
able to find anything. the thing i find interesting is
that if i create a second form with just fields from 1
table i am able to create new or edit records. seems like
as soon as i try to add fields from a second table is when
it will not allow me to edit or add new records from
within the form?
any help would be appreciated
thanks
 
Hi Jason,
first off all you have to check the query.
Open it without the form and try to edit data.
If you can't do this, the kind of query have to be changed.
(Use inner joins, no aggregate funktions ...)

If you can edit your data, open the form at desing mode
and have a look to the editable and the insert property
(at DataTab)

Good luck.
Niels
 
thanks for the quick answer. there is a problem though. i
dont have any queries. i did try to create a query though
with all the same data that i am using on my form (data
from the 3 tables)and NO i was not able to make changes in
the query either.
my goal here is to have a form that has fields from 3
tables and be able to update each tables info from the
form. since i tried to make a form with only one tables
data instead all 3 tables and was able to update and make
changes to fields im thinking that it has something to do
with the relationships of my tables? any suggestions will
help
thanks
 
Jason
try creating a query from the tables then make the form
from the query. Maybe you can also help me. I have
several combo boxes on my form. I want to make other
selections but it just updates my original entry. I need
to keep all the entries. The only way i found any way to
do it was to keep re-entering new records
thanks virginia
 
Back
Top