Search results

Minty, I think you have just given me the push in the right direction I needed! :) Quickly had a play around with the following on the NewTestbtn Private Sub NewTestBtn_Click() DoCmd.OpenForm "frmTestDetail" Forms!frmTestDetail![SO_ID] = Me![SO_ID] Forms!frmTestDetail![ActiveStatus] =...

Apologies Minty my fault for not understanding not yours. It's available as a control in a tab on the previous screen yes. The NewTestBtn is on one of the tabs, and the form itself where the button is on is bound to a query that pulls the information from table1 so I would say yes it is available.

When you say calling the form - do you mean opening it without using the code?

It's populated from a query (or so I assume) The form in question has a query bound to it, within that query I am pulling fields from two tables. chkStatus is coming from a field in one of the two tables, I've simplified what I am trying to do below: Table1: (feed currently comes from excel...

Hi Minty, Thanks for going into further detail! I'd like the combo control to be enabled or disabled based on the value of the chkStatus (which comes from another table) whether it is a new record or existing record. I think this is why I'm having the problem on a new record as the if...

When you say adjust the result accordingly, could you just go into what you mean?

Hi Minty, I think I've found the problem, and of course it is something that I should have spotted long before now but hadn't. It works fine with your code in the On Current even if the form is showing a current record. Where it doesn't work is when the form is for adding a new record (I have...

Thanks Minty, I've run a select query and it hasn't returned any results which makes it even more strange! I was expecting it to return some results based on the previous activity and finding that the debug message was showing the status to be Null. It returns appropriate results if I change...

Minty, Seem's you're spot on. I got the same run time error and in the immediate window it says "Status Null". I'm not sure how or why it is happening as I can see check/no check in the table/query on which the form is based on. The only other thought I've had is that the data in this...

Hi Minty, Apologies but I am not sure I understand? In the table, I see the checkbox checked if it is true and not checked and therefore false. In the table design view the default value is set to false. So I am therefore not sure where "No Value" would come from? With the unbound text box I...

I've just tried unlocking it and adding the code to the checkbox before update event and it works fine using both my original code and the code you suggested Minty. So there has to be something not quite right with the On current or previously on load event? I just can't figure it out :S

If I try without the If statement I get the following error "Run-time error 94: Invalid use of Null"

Hi JHB Yes it works fine and the control is disabled using your suggestion above without the if statement. The checkbox is showing true/false as expected. To confirm it I've added an unbound text box to the form and put it's control source as: =IIf([chkStatus],"YES","NO") Again this gives...

Hi Minty, I've tried it in the On Current event and unfortunately seeing the same behavior. It's enabled either way. I tried my existing code and your suggestion to simplify it. If Me.chkStatus = False Then Me.cmboDASStatus.Enabled = Me.chkStatus End If

Hi all, I'm having some problems with enabling/disabling a comboxbox control based on the result of a checkbox on the same form. I currently have a checkbox control (chkStatus) which is locked so that the end user cannot change it, I then also have a combobox (cmboDASStatus). I'm trying to...

Thanks both, I've gone for a mixture of both solutions as I have quite a lot of data sources I want to pull into the dashboard. Thanks so much to you both for all of the help!

In need of some help and guidance. I'm looking to create a dashboard form, I did anticipate to use the built in graph functionality to create this based on queries I had made. I'm currently having a problem with the graph functionality where I get the following "Automation Error Library Not...

Unfortunately not, as I am using text as well - I had not copied in the full function just the part of it I was focusing on in this post/question. Below is the full code. =IFS(A7="N/A","N/A",A7="Not...

Hello, I currently have the following IF statement =IFS(AF12>=TODAY()-365,"Green",AF12<TODAY()-365,"Red") This gives me... 1. If cell is less than 12 months old = Green 2. If cell date is more than 12 months old = Red I would like to amend it to: 1. If cell is less than 12 months old =...

Is it possible to open a pop up form that contains a datasheet subform and link the datasheet to only show records from the ID on the main form. Button on main form opens a pop up form based on the AssetID from the main form in a list. Currently I'm using a link criteria from the dynamic search...