cant enter data in a form field

G

Guest

O.K. it's a pretty simple "home inventory" style of database that I put
together. Most of the items are working (I think) but in my form I've got
two fields that won't allow me to input anything. One is just a regular text
box and I've compared it to a text box that is working and it appears that
they are set up the same, but still nothing. The non working field is part
of a different table than the working fields and it is "unlocked". The
second field I'm having trouble with is a combo box, which I entered choices,
or values, in when I set up the table. Again it is a different table than
the functioning fields and I can see the choices in the drop down, but it
will not let me choose any of them. This field is also "unlocked. I've
exhausted myself looking for help before resulting to a forum, but I can't
seem to find it anywhere. I know that it must be something realatively
simple. I just wanted to test the waters of Access by building this little
database. Anyway, any help is greatly appreciated.
 
R

Rick Brandt

bcastle said:
O.K. it's a pretty simple "home inventory" style of database that I
put together. Most of the items are working (I think) but in my form
I've got two fields that won't allow me to input anything. One is
just a regular text box and I've compared it to a text box that is
working and it appears that they are set up the same, but still
nothing. The non working field is part of a different table than the
working fields and it is "unlocked". The second field I'm having
trouble with is a combo box, which I entered choices, or values, in
when I set up the table. Again it is a different table than the
functioning fields and I can see the choices in the drop down, but it
will not let me choose any of them. This field is also "unlocked.
I've exhausted myself looking for help before resulting to a forum,
but I can't seem to find it anywhere. I know that it must be
something realatively simple. I just wanted to test the waters of
Access by building this little database. Anyway, any help is greatly
appreciated.

An Acess form can only have one RecordSource so just how are these two
controls using a different table? If the form is using a multi-table query
these can often be rendered non-editable, but that would affect all of the
controls, not just some of them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top