Recent content by xcaliber

Sorry, Harry, that did not work either. I get a syntax error with the # signs.

Hello everyone/anyone: I have two combo boxes; the first is a name for an individual, the second is for the month to which the records need to be pulled. I have the 12 months in a drop down menu. I want to pull any records involving the person and the month. I am having trouble getting the...

Yes I did get to the bottom of it. As usual once you see the solution you wonder why you did not notice earlier. My Textboxes had a control source set to the table. I realized I was setting values to them during run time. ( much like your combo boxes) I made the text boxes unbound and...

Just a thought here. Your problem may be in the if statement. If Me![DateEntered] = "Archived" Then If you do not have the string exactly as shown then it will not enter the if statement. if I understand this correctly Eg: 'Date entered in "Archived", triggers a colour change, and for...

What I think I might be trying to do is dynamically close an openrecordsource. sean

I am curios to know if anyone can tell me how to close an Open Table in a Form. sean

I have a list box which lists the Record belonging to a customer. So, Customer 1, has 5 Unique sales, (Tables looks Like CustID (pk), SaleID (pk), Sales Data ). When clicked on the list box a set of Text Boxes below fill in with that rows Sales Data. You can edit and save all the...