Recent content by Corsica

I've found that the record source of the form is being changed programmatically. Sigh. All is clear now. My sincere apologies for not having checked the event procedures before posting. I have only recently returned to this work. Your time and effort wasn't wasted though as I have learned...

Steve, I did that by copying and pasting after renaming the old form, but I'm still getting the error. I'd got my wires crossed though, the form in question doesn't have many objects on it, so I can build it from scratch, one object at a time if necessary. But not now. I have to close this for...

Hi Steve, I'll do that. I can do that by copying and pasting the hundred, or so, objects on the form.

I ran that compact and repair command in the two ways that I know, but I'm still getting that error. I found another way of achieving the required result, but having an error come up that apparently shouldn't does not fill me with confidence. I still have a lot of work to do on this database.

In the real database the name error is coming up in the second text box. Thank you for all of this. I'm sorry that I can't send you a copy of the database that contains the actual error.

The attachment is the DatabaseForTesting, so that you can follow what I've said. The other real database is large and I mustn't pass a copy to anyone. I wish I could!

It works in my 'database for testing'. I made a table, query and form, and recreated those few things, and I didn't get an error. (I didn't send you the other database not because of the data that's in it, but because I shouldn't show the design to anyone.) I've heard that Access files can...

OK, thanks. I will try to do that now. It may take me a while!

Re: Adding a calculated field to a Form Still getting the same error. I would have named it txt_Height if I wasn't just testing. When I hadn't been just testing, I had a text box called txt_Height2 having control source Height, and a text box called txt_Height having control source Height3...

Re: Adding a calculated field to a Form Hi, many thanks for your replies. I've just redone things: The calculated field in the query is called Height3. The name of the text box on the form is Text136. The control source of Text136 is Height3 (without an =). I didn't type in Height3, I...

Re: Adding a calculated field to a Form I saw this: #Name I found a way to do what I was trying to do, but I would still like to know why using the calculated fields, that were made in the query, as control sources of text boxes on my form didn't work.

This didn't work for me. I wish it had! It worked in datasheet form of the query, but not when I linked the calculated field to a text box on a form. Any ideas, anyone?

Ditto. Many thanks.

This is not longer relevant in that I can now develop in Access 2010, rather than Access 2003. I've tested this in Access 2010 and found that it isn't a problem there. That is, this problem doesn't occur there. Many thanks, again.