Tags: access, cant, database, enter, field, form, home, inventory, items, ive, microsoft, mysql, oracle, pretty, puttogether, sql, style, working

cant enter data in a form field

On Database » Microsoft Access

2,690 words with 1 Comments; publish: Tue, 03 Jun 2008 22:38:00 GMT; (25094.24, « »)

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.

All Comments

Leave a comment...

  • 1 Comments
    • bcastle wrote:

      > 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.

      I don't check the Email account attached

      to this message. Send instead to...

      RBrandt at Hunter dot com

      #1; Tue, 03 Jun 2008 22:39:00 GMT