Search results

Hi, You may want to consider using a cascading combo boxes (you may also search the topic for this). What it does is, when you select WH1 in the first combo box, it will limit the values (or in your case the locations/shelvings) that a user can choose on the next combo box.

Hi arnelgp, Thank you very much because this is exactly how i want it to be! Would you mind if you give me some overview of what the Me.ID means on the last part of the onclick command? I also noticed that you made an IF statement on the onload event of the main form.. I will really...

I hope i attached it right.

Hi arnelgp, thank you for you reply, the letterno is a autonumber field so i tested your code and it opens the form/subform however, it does not apply the filter. it is still showing the first record of the form with subform.

Hi All, I have a continuous Form [Letter Log - All] with "LetterNo" field as the primary key. What i want to do is click the "LetterNo" and a filtered pop up form with subform should appear based on what has been clicked. But i don't have luck doing that. The name of the main form is...

Hi AceBK, On the before insert of your subform: Private Sub Form_BeforeInsert(Cancel As Integer) Me.LineNumber = Nz(DMax("LineNumber", "tb_OrderRequestDetails", "OrderRequest_ID = " & Forms![Order Request Menu]!ID), 0) + 1 End Sub LineNumber is where you want to automatically update the...