Does anyone know if it is possible to have a form that enables user's to update and amend records-the record source for the form is a query with calculations in it. (I need to have calculation's in it to show the values in different currencies)
I have a form where the record source is a query with two tables. There is a one to many relationship between the tables. On the 'one' side there is information on a particular country such as currency, population etc. On the 'many' side there are records relating to particular companies and products that are sold in each country.
I have selected fields from both tables in the query and have also calculated fields which work out the price of a product into different currencies.
I have set 'allow edits' 'deletions' 'additions' to Yes in the forms properties, however it is still not letting me update fields when viewing the form!
I have a form where the record source is a query with two tables. There is a one to many relationship between the tables. On the 'one' side there is information on a particular country such as currency, population etc. On the 'many' side there are records relating to particular companies and products that are sold in each country.
I have selected fields from both tables in the query and have also calculated fields which work out the price of a product into different currencies.
I have set 'allow edits' 'deletions' 'additions' to Yes in the forms properties, however it is still not letting me update fields when viewing the form!
Split your form into two using a main form and subform.
Use linked tables instead of one query.
This is a better way of viewing 'one to many' records than on one form.
Sorry, but I'm still a little unclear as to why it's a better way.
The only reason I ask is that I have quite a few forms like this where I need to do a calculation with currencies-the local currency being a field in the 'one' side table and prices of products on the many side. Is it not possibly to have calculations in forms and at the same time be able to update records?
As a newcomer to Access, this appears to be a major weakness of the application, although I guess there's some very intelligent reasoning behind it which I havn't figured out yet!-I'll have a look at the white paper, thanks for the info!
