Recent content by kodehunt

Yes it is an autonumber. Yes, I see it on the form and in the table. Problem is, and I guess because it is an autonumber, I cannot reference it. The other record is generated on an after update routing if the GRT check box is created. I is an Insert Into command. During this routine is when I...

Both transactions post to the same table as they are really the same transaction, they just decided they want to split out GRT into it's own line item. Even if I did have them in separate tables joined as you say, somehow I would have to capture ID to write it to the second table under...

So I have a list of records in a continuous form. Within that record is a checkbox called GRT. GRT stands for Gross Receipts Tax, when it is checked I have an after update event that adds a new auto-generated record for the GRT entry. The new record copies the date from the origional record...

Exactly right. I had an After Update running on a Parent Combo Box. It's value was a DLookup where I had it set to .value. Once I Just let it default and removed the .value at the end it stopped refreshing. Thank you very much for all of your help.

So I went back to parent/child filtering and remember what my problem ws. When using the parent/child filter method, the form continually refreshes and flashes. Any thoughts on that?

I started with child/parent filtering and for some reason ended up passing the filter via VBA, but I cannot remember why. I will revisit child/parent again and let you know, thanks for the idea.

I have a form "fApprovalPreLoad" with two Combo Boxes, "CBEmployee" and "CBDate". These two Combo Boxes are used to filter another form with several subforms. The code below works great and filters everything fine unless the comboniation of CBEmployee and CBDate returns no results. If no...

I misunderstood your first post, that was exactly it, thank you very much.

Any additional thoughts?

The error only happens when you run the report, not the form. That's part of the weirdness, it's essentially the same code, works for the form but doesn't work for the report.

Here it is.

Checked that and it looks fine. Also if I just type "Spring 2012" (without the quotes, which is the only date available to select at this time) in to the parameter prompt, the report runs fine and filters correctly.

Below is the code I am using to pass a multi-variable string to a report. When I run the code I get the message in the "Parameter.jpg" attachment. I added "msgbox.jpg" attachment to show what the string value is. The NameStr is passing fine, but the dateStr is not. Both are text fields in the...