update data in one table using form

[Smoki]

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)?

 

[Golfinray]

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

 

[Smoki]

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.

 

[Golfinray]

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.