could you not base the (frmLabNotes) on a query, and use the sample entered into the (frmCane2) field as the criteria for the query. Then use an Iif statement in the query to say that if no record matches, open the form (frmLabNotes) where the identifying field has a Null value.
I'm certainly...
Ermmm, somehow, I think when setting the "startup" options, I have turned off all the standard toolbars, and unfortunately don't have a back up (I know, not very bright - Believe me I'm slapping myself!) Is there any way I can reactivate them, so that I can finish the work I was doing...
I am actually using a frm.Filter method from visual Basic - using BuildCriteria to create, well the criteria! I have worked a way around the problem by hand-coding the criteria as a long list with AND inbetween each one, for the third button and it will concatenate the two combo options and...
I have a form, that has 2 buttons to buildcriteria to filter the form according to choices in 2 combo boxes. i.e. in combo box 1 you have a list of clients case status, in combo box 2 you have a list of company representatives.
At the moment, you chose what case status to view (new, offered...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.