Search results

Hello I have a problem with an Iif statement. I have a field which shows a percentage, and I want a message to pop up if the user enters a number lower or higher than a set integer. I have made a macro that does that actual popup, but how do I set up the Iif statement? Thanks for your time Mads

Solved the problem:) Just had to put in a requery (Me![frmSub]![ComboBox].Requery) in the main form field.

Hi! I have a subform with a combo box. The combobox has a query with a condition linked to a field in the main form. What I want is for the combo box in the subforn to show values based on the data in the main form field. As of now the combobox doen't update itself when I change the value in...

I guess what I'm asking is if there's any possibility to run the query in the subform when I change data in a field in the main form?

It seems like the subform only updates every time I open the form? Is there anyway around this?

Hi I have a subform that's based on a query. In the main form I have a field that's linked to the query as a condition. My problem is that the subform doesn't update when I change the fileld in the main form. Does anybody have a solution to this? Thanks. Mads

Thanks, seems like I messed up my formats:rolleyes: Mads

Hi I am using a VBA code to update price and currency values in a drop down menu in a subform. My problem is that the decimals (i want 4) "disappears" through this code. Does anybody have a solution to this problem? This is the code I'm using: Private Sub Product_AfterUpdate() Me![Price] =...

That helped Thanks for your help:)

I have a one to many relationship between the OrderID fields in the main form and the sub form

The order ID is linked from main to sub (one to many realtionship)

I have a field in the subform that links to the main form Autonumber (=[Forms]![frmOrderMain]![OrderID])

Hi I have a problem with a subform. I want to refresh the subform (named frmOrderSUB) everytime I start a new record the main form (named frmOrderMAIN). In other words, every time I push >* in the main form I want the subform to refresh and have no records in the pulldown menu. Thanks for your...