Recent content by rlreynolds217

Task Code is a 13 character string, with the first ten characters being the task code, the 11th being a hyphen, and the last two being the Fiscal Year digits. What I want the user to be able to do is go into an existing task code, pull up the detailed task code form, and be able to change the...

Thanks, pr2-eugin, It is still giving me the error "TPS Database may have encountered an error while trying to save a record. If you close this object now, the databahnges you made will be lost.", and that is even after I changed the last two digist of the Task Code. I also have a linked table...

Hello, I have a form that opens an existing record. I want to be able to save the record as a new record only if the last two digits of the ID (which is called Task Code) are changed. Right now, when I change the ID, it auto saves it in the form, then says I cannot create a duplicate ID...

Hello, I am trying to program a Risk Management Matrix. Once the user selects the risk from a combobox, then the probability and impact should be updated. After the probability and impact are updated (values pulled from the record associated with the combobox record), then the matrix should be...

PBaldy, I was unable to send the database due to the nature of it, however I was able to fix the problem on two of the three forms that I needed to access. The problem was that I was using the name "Report Center" in the syntax when I needed to use "NavigationSubform". Here is an example of...

Dumb question...how do I post it in here?

No, it doesn't, which is the problem. It only works when I open the form "Report Center", as a separate entity and not while accessing the NavigationForm "Main".

Here is the syntax that it comes up with with adding the subform...and I still get the "Enter Parameter Value" box...as I stated, it gives me what I want when I access the form by itself... [Forms]![Main]![NavigationSubform].[Forms]![Report Center]![cboTPSbyPMS]

I think we were typing at the same time...I went in and tried to adjust the query statement. This is what I have in my query right now... [Forms]![Main]![Report Center].[Form]![cboTPSbyPMS]

PBaldy, thanks for your response... So maybe I can explain this better? I have a NavigationForm(called Main) and a NavigationSubform(called Report Center). There is a combo box on the NavigationSubform(Report Center) that allows the user to select the filter(TPSbyTaskMGR), then a command...

Hello, I am trying to use a drop down list to get values (which are grouped), then clicking "Preview Report" to view the report based on the values that are selected by the user. When I try and use the "Preview Report" button from the Navigation form, it comes back with the parameter...