Recent content by Aberrant_Geek

Single Record

Hey all, I have a form, frm_Master we'll call it, and on that form, within it's 'form footer' I have a tab control containing a few sub-forms, namely frm_Child. Now, if I turn on my form footer's visibility, then the form's detail section is not shown; likewise, if the form's footer is not...

Lo and Behold, the issue has been resolved. I reverted the code to the proper form (as suggested above, shown below), but I was getting the same error. I assumed it was something wrong in the Query. So I tore it down and rebuilt it up. I changed the Parameters from [Reference ID] to...

Unfortunately, I will not be able to upload a database for you (Dummy or Otherwise), as all the queries are to linked .dbo objects. I'll do my best to include all the relevant data here. My only coded module, aside from generic debugging and form commands, looks like this: Option Compare...

Actually: I messed up, and will have to put this all on hold. I appreciate the responses, but I'll have to get back to this at a later time. :(

I can't upload the entire db (as per restrictions from the project manager), but I'd be happy to upload a dummy database with the form and table. Will that do?

Hey, thanks for the quick reply. The error is highlighting the OpenRecordset line of code, I've tried the method you're suggesting before and the result was an error, "Expecting 2 Parameters".

Hi all, and thanks for taking a look. Here's my Goal: To open a saved query that has a parameter, setting that parameter via a VBA sub. Here's my Problem: I was getting various errors, but after debugging my program a bit, it comes down to a "Data Type Conversion Error" Here's my Code...