Updating a field on a form

[paul.clarke]

I created a query to display data from multiple tables, then created a form using this query. You enter a product code and the details are brought up.

1 of these fields in the query is "comments" I want to be able to update the "comments" field from the form, I can click in the field but i cannot type anything. It will only display the comments if any.

The only way i can update them at the moment is to update the database table directly or via a comments form i created, which is a blank database and you enter from scratch.

I would prefer to enter the comments on the form which in turn updates the database table. This must be possible. Is it property setting, coding etc

Any suggestions?

 

[HiTechCoach]

I created a query to display data from multiple tables, ...

Great for report. Multi table queries can easily become non-updatable which mean not good for forms when you want top edit data..

... then created a form using this query.

Be careful that your queries remain updatable or you will not be abel to edit any of the data.


I find it it best to limit a form's recordset to a single table. Use sub forms to display/edit data from related tables.

 

[paul.clarke]

Thanks, im fairly new to forms, i had a go at sub form but couldnt seem to link the tables, how is this done? and will this allow me to update the comments field from a form?

 

[CEH]

I would take a look at your relationships..... And look at the forms "Data Entry" property... There is NO reason a multi table query should not work. Sorry to say..... But I think a form for every table would be a nightmare for a user..... It would become confusing and very time consuming. I rarely have only one table in a query.

 

[paul.clarke]

I would take a look at your relationships..... And look at the forms "Data Entry" property... There is NO reason a multi table query should not work. Sorry to say..... But I think a form for every table would be a nightmare for a user..... It would become confusing and very time consuming. I rarely have only one table in a query.

i have multiply tables in 1 query. and i am experienced in queries and tables, but not forms, however the form displays everything i need from the different tables, only stumbling block was the comments field, would not let me type in the field on the form, i have no experience in coding so wanted an easy way to update this field. i have now used a subreport/subform which does the job sufficiently.