update data in one table using form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smoki - 22 Apr 2008 09:59 GMT

Hi,
I want to update data in table using form. I have 1 combo box on my form,
where I choose one number from 1 column in table, and then, all other fields
on my form have been filled in. And now, I want to change some information
about that number.
How can I do that? Do I have to use form with subform? I read that I can
update table using form, only if I use form with subform, and in the main
form I have this combo box, and subform has these other fields whitch I want
to update.
But, how to create form with subform if I have only one table (so I don't
have one-to-many relationship, which I need for Form with subform)?

Reply to this Message

Golfinray - 22 Apr 2008 13:35 GMT

You should not need a subform, just the form will do. Use the form wizard, if
necessary, to add your form and all the fields you want. Put a command button
on the form (use the command button wizard) that closes and saves entered
data.

> Hi,
> I want to update data in table using form. I have 1 combo box on my form,
[quoted text clipped - 7 lines]
> But, how to create form with subform if I have only one table (so I don't
> have one-to-many relationship, which I need for Form with subform)?

Reply to this Message

Smoki - 22 Apr 2008 13:46 GMT

But, my form doesn't let me to enter anything in text fields, it says:
Control can't be edited; it's bound to the expression 'Number.column(1)'

I got this message every time when I try to add, or change data in those
text fields. So, command button can't help me, in this situation.

> You should not need a subform, just the form will do. Use the form wizard, if
> necessary, to add your form and all the fields you want. Put a command button
[quoted text clipped - 12 lines]
> > But, how to create form with subform if I have only one table (so I don't
> > have one-to-many relationship, which I need for Form with subform)?

Reply to this Message

Golfinray - 22 Apr 2008 19:31 GMT

Check and see if your query is editable, meaning at the bottom there is an
arrow and asterisk. If the query is not editable your form won't be either.

> But, my form doesn't let me to enter anything in text fields, it says:
> Control can't be edited; it's bound to the expression 'Number.column(1)'
[quoted text clipped - 18 lines]
> > > But, how to create form with subform if I have only one table (so I don't
> > > have one-to-many relationship, which I need for Form with subform)?

Reply to this Message