Recent content by 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...

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...

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...

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...

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...

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...

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...

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!