Search results

The record source is a table. I wonder if the fact that the Table (CDLExam) has the same name as the form (CDLExam) might be an issue...?

I did, without issue. It didn't change a thing!

Ok. I'm trying and still having issues. I apologize for being so stupid. Here is what I came up with: I get an application/object defined error on the highlighted line.

So when I try this method it says that GoToRecord isn't available. I have the focus set to the subform, so I don't know why it wouldn't work...

Would that looks something like this?

Yeah, I kind of blabbered on. Just wanted to make sure I was giving you guys as much as I could. The subform isn't linked in any way to the parent. The parent form's sole purpose is to be a physical GUI to manage the subforms. To be clear, I don't want to FILTER the subform down to the one...

So that does the same thing my code does. As an update, it turns out that my third line is actually doing SOMETHING. I couldn't tell because I hide the main Access window, but it DOES open the correct form in its own tab, to the correct record, in the main Access window. So, basically...

Here is my current setup: I have a Main Form with a tab control. On each of the six tabs is a SubForm that takes up the entire tab. So basically I have a tabbed interface for my forms, just with a bit more control over the layout than if I just opened the forms separately in the Access window...

So I solved it using the following code in the OnChange event for the Badge textbox:

So when I do that, it does NOT ask me for a parameter value, so supposedly it's finding the text box, but it doesn't display ANY records, no matter what I type into the box. And yet, when it WAS asking me for the parameter value, and I typed in a badge number that exists in the table, I DID get...

That does not work. CDLExam is a Table. As soon as I open the form, I get the "Enter Parameter Value" textbox, so it's a problem with it understanding that [Badge] refers to the textbox called "Badge" on that form.

So I'm tearing my hair out over a really STUPID problem: I have a continuous form... and I want to filter the table in the background using the text box called "Badge" (boxed in red in my picture.) You can see the corresponding part over in the filter field. When I display the form, though...

That's an interesting solution. It becomes a bit clunky when I've got a huge bunch of combo boxes, but it's still cleaner than the alternative method of a completely different table for each combo. I might do that! EDIT: This works great! THANKS!!!

I suppose I'll just do that. My OCD self hates to have to create so many extra tables, but such is life I suppose!

I was thinking about doing that, and will probably have to. I was trying to avoid that because there are many forms with tons of combo boxes and I was trying to avoid cluttering up the tables list with 30 different tables for combos. I wish you could have one "master combo" table where you...

I have a form with some combo boxes. The users need to be forced to enter ONLY one of the given options, so I have disabled the "Allow List Value Edits" field so that the little "edit list" icon does not show up under the drop down in form view. However, some admins need to be able to go in and...

Nevermind guys! Turns out what I was doing was right, but the form's properties had "Allow Datasheet View" set to 'No'.

Hey guys, I think this is a relatively simple problem... we shall see. Let's say I have a form. On this form is a tab control with 5 tabs. Four of these tabs have subforms on them. The 5th tab is sort of a "settings" page. What I would like to do is have a button on the 5th tab, that toggles...

I should add that there is something that seems awfully shady about the way this is running. It really slows things down. The two tables only have 50 records each, and yet this concatenation function makes the query and report go from running instantly, to taking 2-3 seconds to refresh every...

I had actually already tried that. I had added: GROUP BY SrvcRest.ID but that throws up the following error message: "Cannot group on fields selected with '*' (SrvcRest)."