Recent content by Mast0645

I am working on recreating an excel file in access. My excel files uses the Vlook up function to get data from a table for calculations. I am calculating Fruit Solids. =VLOOKUP(BRIXVALUE,'Brix Table'!$A$1:$F$752,6)*QUANTITY (BRIX VALUE references a cell, and quantity references a cell just...

Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Product_Status.Value) Then Me.Product_Status.Value = "Status Assignment Needed" End If End Sub Private Sub Form_Current() If IsNull(Me.Product_Status.Value) Then Me.Product_Status.Value = "Status Assignment Needed" End If End Sub...

I got it to do some of them but then I changed the event to Before Update and things stopped working. I switched it back to both Open, Current and Load events and now nothing updates in the combo box. Unsure why it worked only in some boxes for a moment or two.

Thank you, I also have another question. I don't know if it is possible to do. I am using the same combo box Product_Status. I want the user to be reminded when they leave the Product status blank. I created a new item to the list box called Status Assignment Needed. I tried using the Form...

If Me.Transaction_Type.Value = 1 Then Me.Product_Status.Value = "Unallocated" End If This made the code work. Thank you so much.

I will try that thank you, ill let you know if that works or not. :)

I am not sure if I have it bound. I am still learning access and vba code. The two "combo boxes" are part of a subform (referencing a table, those fields are linked to other tables which populate them with drop down options). So my main form is Products and the sub form deals with the...

I have a form where I have two drop down list box. The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated. I have...