Recent content by Blabolat

This is probably really easy and I just can't figure it out. I have two true/false check boxes on a form, one for Paid and one for pickedup. On the query builder I have these two fields listed, and I want the records to show on the form if either box is not checked(false). So in the Query...

haha! you were? well, I thought I came upon something, but then yeah, I"m sure you would have suggested it. thanks! Along the way I found another trick. I have a filter that I use a text box and a button to find what I'm looking for. Well I was getting errors if I didn't put any number than...

Soo I think I figured it out. quite simple actually, I created a 2nd form and set it to be a popup model. Fact is, I think this will work out even better, than going to the record on the main form. Thanks!

Main form SOID linked to Service Detail form by SOID. Service order primary key is SOID Service Detail primary key is SDID and linked using soid The skinny form is exactly the same as the service detail form. should the skinny form be somehow linked to the Service detail form somehow...

So I have your main form and the sub form (Service Order/Service Detail) I had originally had a continuous detail subform but found it didn't work well so I switched to a singe form. The trouble is, you don't get a peek at the other Details of the subform. Ideally I would want to use a...

As I suspected, does not work in a continuous subfrom mode. Worked perfectly in 'single form' mode. I"m getting to suspect, that the continuous mode was a after thought, and just threw in without the same benefits as the single form mode. ON a similar note though, Is there a method to have...

Oh, I set the field to be required in the Table design. However, the error message, "You must enter a value..." pops up upon entering the form.. don't know.

Thank you for your answer and reply. It's basically what I had tried earlier and with the same results. The form I speak of is a continuous form and only until I get to and through the following form does the message come back. Now, it will come up with an error, since the focus is now on...

Thanks for the heads up, it's just how I termed it. Unwittingly I created a If isNull and object = "". probably late at night and I used blank and now I know some more. thank you.

This probably elementary, but for the life of me I cannot figure out how, though, I have researched the net for an answer. I"m sure it's a pretty easy answer. Have Main/Subform combo. In the subform I have a field, [service_detail] that if left blank I want the user notified. I created a If...

I have this Filter that I use to select the frameID It works fine, if there is a frame Id, I use a if statement to send a msgbox if the value is null or "". This is the filter. Private Sub qstxt_AfterUpdate() DoCmd.SetFilter "", "[FRAMEID] Like """" & [Form]![QuickString]![qstxt] & ""*""", ""...

Thank you, those are great references.

Never mind, found the solution.. I'm going to thank myself. On another note. one of the hardest things for me to do was learn syntax of Forms,fields,commands in VBA.. So my solution was to, from where I was, go into the "expression builder", and go down the hierarchy of the Forms, records...

OK its been one head banger after another, and it has been a head scratcher with every issue, but with google and help from everyone here, its getting done. I have a silly issue that is driving me crazy, because I don't know how to google it. I have the form and sub form. Very little if any...

Wow, thank you, That is exactly what I want to do. I think I did come across a solution very similar to yours and this is what I did (I had to change the Form names and some of the other labels as it was getting to confusing for me how I originally created it, so I simplified it, but the...