Recent content by Oviziest

  1. O

    Solved How to reference a unbound combo box column in Ms Access

    you're referencing the column in your code for the unbound combo box. Have you tried checking the index number you're using for the column in Me.CboQuotation.Column(2)? Sometimes it might start from 0 or a different number. Double-checking that might help fix the issue you're facin
  2. O

    How are you Guys?

    I'm good, thanks. Long time no see indeed! Congrats on getting picked by the MNC. Starting on the 11th? That's awesome!
  3. O

    Code to select which subform to open from mainform.

    for the code part, if you're using something like Access, you can try this: vbaCopy code Private Sub Button_Click() If condition1 Then DoCmd.OpenForm "subform1" ElseIf condition2 Then DoCmd.OpenForm "subform2" End If End Sub You'd have to replace condition1 and condition2 with your actual...
  4. O

    Use tempvars to open a related form

    So, it sounds like you're dealing with a situation where a "phantom" record gets added if the user closes the form without entering data. To avoid this, you're thinking of triggering the code on the 'beforeupdate' event instead of the 'onload' event. The idea is to make sure the code only adds a...
  5. O

    Solved Expression Builder Latest Date in Forms

    Looks like you're trying to fetch the latest date from a table into an unbound text box using the expression builder. Sometimes, getting the syntax right can be tricky. Double-check if the table name and field are spelled correctly in your DLookUp formula. Maybe that's where things are going a...
See more
Back
Top Bottom