Recent content by mebdrew
-
M
Solved Button on one form selects listbox item on another
I am not a fan of multiple forms being open for a variety of reasons. In this case, the New Case form is rare to be opened, the form I am updating is the master view, which handles a vast, vast majority of functions (and the functions it doesn't handle do not interact with the master view)...- mebdrew
- Post #7
- Forum: Modules & VBA
-
M
Solved Button on one form selects listbox item on another
That worked wonderfully! The listbox also searches for a record, but I have that part down. I can't believe this was so simple! THANK YOU!!!- mebdrew
- Post #6
- Forum: Modules & VBA
-
M
Solved Button on one form selects listbox item on another
I used this code (COEMR is one of the fields) I assumed I needed to declare vNewNum unless that's a function I'm now aware of? Private Sub Command81_Click() Dim vNewNum As Integer vNewNum = Me.COEMR Forms!FrmAllTracker!NewCaseList.Requery Forms!FrmAllTracker.NewCaseList = NewCaseList(vNewNum)...- mebdrew
- Post #3
- Forum: Modules & VBA
-
M
Solved Button on one form selects listbox item on another
I have two forms in question. FrmNewCase is where our admin enters a new case. FrmAllTracker is where several list boxes are referenced, which include New Cases, Case Under Review etc. When she enters a new case on FrmNewCase and hits save, I want FrmAllTracker (which is often already open)...- mebdrew
- Thread
- Replies: 6
- Forum: Modules & VBA
-
M
Getting IIf to return a null value if True
Howdy all! I've tried hard to scour the web for an answer before posting, because no one likes answering the same question twice! I've not found anything but I am happy to be re-directed. ? The query is looking to either display all the cases in the table that do not have a close date...