"Field cannot be updated"

R

Radhika

I have a form which has a text box with the following properties (the form is
not linked to a specific table or query):
Name = txMonth1
Control Source = 1
Visible - No

The form is linked to a subform. This subform is bound to a query which has
the following expression: TheMonth: Month([Date])
This expression gives me a '1' for January Dates, '2' for February Dates,
'2' for March Dates and so on...
The form and subform are linked in the following way:
Link Child Fields: TheMonth
Link Master Fields: txMonth1

However, when I try to add a record, I get the following msg: 'Field cannot
be updated'.
How can I fix this?

Thank you,
Radhika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking One child field or another in subform to main form 4
How do I get a query supplied date into form not based on that query? 1
Link subform ID control 3
Change subform veiw 1
Update query 2
Can't add a record to a subform 1
A question of design 1
Count and sum per month in a query 2

Top