Cannot edit textbox after save

[BreadWinner]

Hello, I have a question about textboxes. After opening my form, I cannot edit textboxes. If I enter anything in control record, it gives me a #Name? error. Thanks for any help in advance!

 

[veraloopy]

Check that in the properties of the form itself, you have Allow Edits set to Yes

For the ?Name error, have a look at this help page:

http://office.microsoft.com/en-us/access-help/i-see-name-displayed-in-a-control-HA001181447.aspx

 

[BreadWinner]

Veraloopy- thank you for your reply, the form is set to allow edits. Unfortunately, the normal problems for #Name? don't seem to include my problem (but I'm fairly new at this, so there's a good chance I'm wrong.)

Pat- thank you for replying. I may be misunderstanding your question, but I don't think I'm trying to use a query. If I try to write =[Text54] in the record source it gives me the #Name? error.

 

[BreadWinner]

Thank you!!!! I want to make sure I understand the problem and how to fix it. When I created a textbox and set the ControlSource = [text54], it was not saved because it is unbounded?

From my understanding, in order to fix this problem, I have to change the name porperty so it can be referenced in a ControlSource?

Thank you again for your help- I would have been very lost on this problem.

 

[BreadWinner]

Thank you very much for being so patient with me. Now that you've shown me the problem, I've tried reading about it, but I am doing something wrong. I had two unbounded controls. I deleted their ControlSource property and tried to do what what you suggested:

Me.txtTitle_Name = Me.txtText56
(I used to have =[Text56] in the ControlSource)

Me.txtImpact_Name = IIf([Cost_Name]>=[Performance_Name] And [Cost_Name]>=[Schedule_Name],[Cost_Name],IIf([Performance_Name]>=[Schedule_Name],[Performance_Name],[Schedule_Name]))
(this expression used to be in the ControlSource)

Thank you again for the help, I would really like to understand how this works- I have a feeling it will greatly improve my work in Access in the future.

 

[BreadWinner]

Error message is #Name? When I enter this expression (a max function):

=IIf([Cost_Name]>=[Performance_Name] And [Cost_Name]>=[Schedule_Name],[Cost_Name],IIf([Performance_Name]>=[Schedule_Name],[Performance_Name],[Schedule_Name]))

in the Control Source for a textbox it worked until I saved and reopened the database. It then gives me the error message #Name?

I understand now that I must change it to a record source in the table from which the form was created. Is there a link that you know of which can help me learn to do this?

I uploaded my database in case others had similar problems. The problem is with the form named "Risk Overview" and the error is in the textbox below the rubix cube.

As always, thank you for your help.

 

[BreadWinner]

A compile error- thank you! I will take your advice in the future and use a consistant naming standard (one without spaces too!) I really can't thank you enough for your time.
I have fixed the error now, but realize that the value calculated in the form is not making into the table. (because its unbounded). Do you know how I could calculate the max value of three number (like the form does) using a query so it shows up in the table? Or just a resource that could help me with this, I have taken enough of your time. Thanks again!!

 

[BreadWinner]

You are right- I don't really need the calculated value. However, I do need to use the calculated value as an argument for a Dlookup and need to save that. I tried doing the DLookUp how you suggested, with code, and in a query (unsuccessfully). I really feel like I am missing something, because I'm understanding and following the directions from what I've researched and done before, but I think it may be more complex than the examples.

I used the value from the form which I was trying to calculate (Impact_Name) in the update query:

DLookUp("Score","[Risk Matrix]","Impact=" & [Forms]![Risk Overview]![Impact_Name] And "Probability =" & [Forms]![Risk Overview]![Probability_Name])

Again- I appreciate your patience; I know that I'm not getting this quickly. Thank you.

 

[BreadWinner]

Pat- thank you for your help, I finally figured it out (with your guidance!)

If anyone is interested in the details here they are:

I ended up creating an update query using DLookUp and If statements, triggered by "On change" in the combo boxes. Not the most elegant solution, but it worked with Pat's help and patience!